Hi,
I am importing data from ODBC stage to a table in Teradata and using a transformer to combine date and time cols to load as timestamp in TD.
As there are some duplicates in table, i am using Remove Duplicate stage to remove those duplicates and they are row level duplicates, but when i am running that job it is giving me error as:
Transformer_4,1: Fatal Error: Invalid Julian day [date/date.C:1001]
I am using remove duplicate stage between transformer and TD stage.
Please help...!
Thanks...!
Invalid Julian day [date/date.
Moderators: chulett, rschirm, roy
For StringToTimestamp you will have to provide the format of the input string.
In your case the format is "%yyyy-%mm-%dd %hh:%mm:%ss".
So the derivation would become
StringToTimestamp(DateToString(DSLink3.DAT):" ":DSLink3.TIM[1,2]:":":DSLink3.TIM[3,2]:":":DSLink3.TIM[5,2], "%yyyy-%mm-%dd %hh:%mm:%ss").
Try this.
In your case the format is "%yyyy-%mm-%dd %hh:%mm:%ss".
So the derivation would become
StringToTimestamp(DateToString(DSLink3.DAT):" ":DSLink3.TIM[1,2]:":":DSLink3.TIM[3,2]:":":DSLink3.TIM[5,2], "%yyyy-%mm-%dd %hh:%mm:%ss").
Try this.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: