DSXchange

Helo, I have developed an job in XML using Row Geenrator, Transformer, XML_Input stage and Peek Stage. Here in this Row Generator i have generated an row as "Name" and in the transformer i gave the path name as "D:\DW\DSFiles\XML\testing.xml" in the "Name" Derivation. I...

Yes i got it thanks to all.

Atlast the StringtoDate() was converted into the Oracle table.

It worked because the mistake was done in concatination.

Thanks to all.

Regards,
Siva

my doubt is on StringtoDate() convertion ....................... My input date is 1052003(dmmyyyy).I am getting this field as a varchar field(length 7). I want to convert this into date field(yyyy-mm-dd) In transformer i am using the function StringToDate() I assume StringToDate() takes only the exa...

my doubt is on duplicate entry key warning. while comparing the two tables in delta processing yesterday data and today data are compared in Change capture stage with the same metadata. its working fine with the values and gets loaded in the dataset but in the director it shows "Ignoring Duplic...

my doubt is on StringtoDate() convertion ....................... My input date is 1052003(dmmyyyy).I am getting this field as a varchar field(length 7). I want to convert this into date field(yyyy-mm-dd) In transformer i am using the function StringToDate() I assume StringToDate() takes only the exa...