Date Issues

[aag12]

Hi All,

Am experiancing a strange problem. We are trying to insert a date field from Oracle to Teradata Table.A Simple mappig and no other processing involved. But The records are always getting rejected with Invalid operation on ANSI Date error. We used expression transform to format the date into the default format as specified in Teradata,Still we are getting the same errors. Anyone plz help me out here....

We tried writing to file after using expression transformation and was surprised to see that even after using expression transformation and all formating the date is still default Informatica format and not in the format we specified..

Thanks In advance..

 

[blom0344]

Can you post the exact transformation code?
Did you use verbose data logging on the expression transformation to see what happens during processing?

Ties Blom
Information analyst
tbl@shimano-eu.com