Timestamp Error - Code:6760

General

Timestamp Error - Code:6760

Hi 

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)
1 REPLY
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.