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.
TPTAPI requires that TIMESTAMP data be passed as a character string.
For TIMESTAMP(0) use 'yyyy-mm-dd hh:mi:ss' format.