Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Jun 2011 @ 14:11:25 GMT


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


Subj:   Loading Data from Oracle to Teradata through TPT
 
From:   Yong Boon

Hi Teradata Guru,

We're exploring the solution to Pull (aka Pull Method) the data from Oracle Server and load to Teradata, l understand that the TPT ODBC Operator and the LOAD Operator could perform such operation without the intermediate staging file.

Is DataDirect ODBC driver a MUST for TPT ODBC operator to interface with Oracle, could we use the native driver provided by Oracle?

What's the common issue faced by the Pull methods experienced in your site? We're currently loading the Oracle to Teradata through files in the staging server.

Thanks in Advanced.


Regards,

YB.



     
  <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