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,
Warning while populating into target table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon Dec 29, 2008 2:22 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 35
- Joined: Mon Dec 29, 2008 2:22 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: