Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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.

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