DSXchange

Hi

When loading null date into Oracle table using the Load functionality the dates are getting loaded correctly but while using the upsert functionality Update then Insert a strange value like '30-12-1899' gets loaded for null values. Can someone explain this ocurence or a workaround it?

Welcome aboard.

Does the Oracle table have this as the default value for this date column?

i thing u just insert date as a default in job property
or
if u using transformer stage there u must choose datatype date


------------
rajeshds