DSXchange

Hi,

I have developed a job(Seq file -> Transformer -> Oracle) form Seq file I am pulling the date column values(Some values are null also) which are Varchar data type and in transformer I am using the StringToDate function to convert these Varchar into Date type. When I am running this job I am getting the below warning.

APT_CombinedOperatorController,0: Conversion error calling conversion routine date_from_string data may have been lost

Please let me know what might be the reason and how we can eliminate this warning

Thanks in Advance

Regards
Sridhar

Start by disabling operator combination so you can determine precisely which operator is generating the error.

Well..

you have to verify the contents of the particular field before perform the actual conversion.

you should do something like below Edi