Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   TimeStamp from Oracle to Teradata
From:   RLavadi

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.


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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023