Timestamp Error - Code:6760


Timestamp Error - Code:6760


We are using Informatica to load Teradata table from Oracle.

With normal mapping the data is getting loaded in table but the data load speed is very slow.

So are using TPT via Inofrmatica, but getting error for timestamp.

In Oracle the column data type is DATE and in TD it is TIMESTAMP(0).

Could anyone help on this please.

Thanks in advance.

Tags (1)
Teradata Employee

Re: Timestamp Error - Code:6760

TPTAPI requires that TIMESTAMP data be passed as a character string.

For TIMESTAMP(0) use 'yyyy-mm-dd hh:mi:ss' format.