DSXchange

I am using the same value...

Hi Thanks for the reply,
Below are the details


To figure out the exact problem we need additional info..
1) How many columns do you have?

50 Columns

2) What are the key columns and value columns?
only one is the key column and i mentioned

changemode = explicit keys and values

Hi All, I am using ChangeCapture stage to compare 2 datsets in my job. I am getting below warning message: Change_Capture_8: When checking operator: Defaulting "ACRL_MTHD" in transfer from "beforeRec" to "outputRec". How to over come with this warnings? I am getting thi...

Hi JoshGeorge,

Thanks for the reply,I rewrite the code as below and it is working fine now..

DateToString(StringToDate(Left( from_funnel.EFCTE_CLCLD_DTTM, , "%yyyy%mm%dd"), "%yyyy-%mm-%dd")

Hi All, I used below code to populate in one of my target field as below format. CCCC-MM-DD HH:MM:SS. code is: TimestampToString(StringToTimestamp(from_funnel.EFCTE_CLCLD_DTTM, "%yyyy%mm%dd %hh:%nn"), "%yyyy-%mm-%dd %hh:%nn:%ss") but now my requirement is to poulate only 'CCCC-MM...

Hi,

Will Left function work in my scenario(means for integer type)?
Left((inputcolumn), 3)="700" or
Left((inputcolumn), 3)="701"

Hi Maveric Thanks for the reply,

It is very usefull forme,if you help me by giving exact derivation to me.

Hi All, I need to write some derivation in my transformer like below: if sourcecolumn1= 300 or 300% then populate 'xx'else blank. my intension is, if the values are in source like 300 or 30045 or 30076 or 30088etc,whatever starts with 300 i need to populate as 'XX'. SO below logic will work IF sourc...

Thanks for your reply chullet, Othere than that if TARCOL2(second source column) also null then populate TARGETCOL with TARCOL3(3rd source column).. so to populate TARGETCOL: if the value of the ColumnA = 'dsx' then map TARCOL1, Else map TARCOL2.if this column value(TARCOL2) is null then mapTARCOL3....

Sure and I mentioned clearly now about my reqrmnt in my original post..

thanks

Hi Chullet,

ColumnA,TARCOL1,TARCOL2 & TARCOL3 are my source columns:

And i have to populate one my target column(TARGETCOL) like below:

if the value of the ColumnA = 'dsx' then map TARCOL1,Else map TARCOL2.if this column values is also null then populate TARCOL3.

Hi Chullet,

Thanks for the reply,

And my reqrment is like:

if the value of the ColumnA = 'dsx' then populate TARCOL1,Else populate TARCOL2.if this column values is also null then populate TARCOL3.

Hi All,

Can any one explain,How to use 2 else statements in if-then-else statements in transformer stage.

reqrmnt is:

if columnA='DSX' then populate col1,else col2,else col3.

can any one please help me on this..

can any one helpme on this please?

Hi ,

values are in my columns are varchar type.So some are the values are nulls.

rqrmnt:

if the value of the ColumnA = 'dsx' then populate TARCOL1,if this value is null THEN populate TARCOL2.if this column values is also null then populate TARCOL3.