Warning while populating into target table

nagarjuna900 · Post by **nagarjuna900** » Mon Jun 21, 2010 2:00 am

HI,

am getting two input fields Date and Time in Varchar. I have converted into Timestamp format. While loading into the target table the values are populating into the table and am getting the below warning for all rows.

Order_History_Stg,0: Warning: At row 128574, link "lnk_staging", while processing column "rb_OrderCloseExpireDateTimeGlobal"
Value treated as NULL
Attempt to convert String value "" to Timestamp type unsuccessful

How to resolve the above warning.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2010 2:18 am

Make sure that the string that you construct satisfies the format specified in your timestamp format string (default value can be viewed on Parallel tab in Administrator client) or provide a non-default format string in your StringToTimestamp() function.

nagarjuna900 · Post by **nagarjuna900** » Mon Jun 21, 2010 3:19 am

all the values are inserting into target table with exact values. if any null values exist that are inserting as NUll.
values are inserting with exact values.
Also warning is comming in log.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2010 3:21 am

Read the error message. Then know that "" is NOT the same as null. Fix that.