DSXchange

Hi All,

I am doing lookup on 2 tables, the source table has duplicate records and giving out the output to 2 diffrent Sequential files.Is there any function that I can use in tranformer so that unique records are loaded into one of the sequential file.

Any help Please.

Thanks
yar

Hi All, I am trying to lookup 2 tables to load my target Sequential file,but i am getting a warning Untitled4..Transformer_22: Reference lookup generated 4 rows. Only the last row was used. I am using the Trim Function in my Source SQL,when I am Extracting the Data Any Help Please Thanks yar

Hi All,

I am trying to convert Date format from MM/DD/YY to YYYMMDD

I am using the function

Oconv(Iconv(InputLink,"D2/","D YMD[4,2,2]), but I am getting Space between.Like YYYY MM DD.

Can someone Please help me


Thanks
yar

Hi All,

Can any one please let me know what does the pattren "+" and "++" mean in Quality stage output.


Thanks
yar

Hi Chulett, Thanks for the reply, But I am Converting from varchar to decimal in the "Modify Stage" I am using the following Specification in Modify Stage Column_Name:decimal = handle_null(Column_Name,0). Please let me know if this Specification is correct. Thanks yar

Hi all, I am trying to convert the source data type from Varchar to decimal and am using the Modify stage. I am getting this warning When checking operator: When binding output interface field "column_nmae" to field "column_name": Implicit conversion from source type "ustrin...