I am trying to insert record into a Oracle table with Timestamp field. I have 'StringToTimestamp' function in the transformer stage to convert the Varchar data to Timestamp. Transformer is happy with the function but records not loaded to the table and job does not complain either! Job finishes successfully but table is still empty.
How can we do 'String to Timestamp' transformation in Parallel job?
Thanks,
Uma.
Timestamp Trx in DS-PX
Moderators: chulett, rschirm, roy
Hi Uma,
How did you come to know that the data is not inserted into the table beacuse of the timestamp field.
The default format of timestamp is YYYY-MM-DD hh:mm:ss. Is your incoming string in this format. If your incoming string is in someother format then you have to use the format options available in StringToTimestamp function.
HTH
--Rich
Pride comes before a fall
Humility comes before honour
How did you come to know that the data is not inserted into the table beacuse of the timestamp field.
The default format of timestamp is YYYY-MM-DD hh:mm:ss. Is your incoming string in this format. If your incoming string is in someother format then you have to use the format options available in StringToTimestamp function.
HTH
--Rich
Pride comes before a fall
Humility comes before honour