Archives of the TeradataForum

Message Posted: Mon, 08 Nov 2010 @ 19:44:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Dear Experts,

We are in the process of taking Oracle Data into Teradata, one of the conversion tools is 'Informatica'.

All data fields are getting into Teradata table from Oracle, except 'Oracle TimeStamp Field' ! This is getting truncated while getting loaded into Teradata through Informatica.

e.g

We see value of a timestamp in Oracle Table is : 01/01/2010 4:16:48 AM

After loading, it is seen in Teradata Timestamp field is : 01/01/2010.

Any tips, would be appreciated. Thanks.

Ravikumar Lavadi
Vice President
Pershing Technology Group - NetExchange Information Delivery

	<Prev	Next>		<<First	<Prev	Next>	Last>>