Archives of the TeradataForum
Message Posted: Mon, 08 Nov 2010 @ 19:44:21 GMT
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|