Invalid Julian day [date/date.

[Simar]

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...!

[Maveric]

Looks to me like a concatenation mistake. Post the derivation you are using to concatenate the date and time fields.

[Simar]

Hi,

Here is the transformation iam using

StringToTimestamp(DateToString(DSLink3.DAT):" ":DSLink3.TIM[1,2]:":":DSLink3.TIM[3,2]:":":DSLink3.TIM[5,2])

In this case DAT: 2007-08-13
and TIM: 16184530

Please let me know in case you require any oher info.

Thanks...!

[Maveric]

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.

[ray.wurlod]

Isn't it "%nn" for the minutes component? And isn't it the case that you don't need the format string if your timestamp is in the default format?