Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 30 Nov 2006 @ 18:46:36 GMT


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


Subj:   Re: Performance Tips for SQLPLUS / Named Pipes /
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, November 30, 2006 13:42 -->

Mohommod.Khan writes:

  Since you are extracting all your data and loading it to empty table, try extracting the oracle data onto flat files, delimited. Now load it using FastLoad. Compare the load times. The other option would be using Ole Load or warehouse builder but they use odbc and I doubt they will be faster than the named pipe.  


The comment about OleLoad is misleading. I think OleLoad only uses ODBC for initial job configuration. The actual transfer of data into the Teradata database is done using a load utility such as FastLoad. ODBC is not used in this data transfer and my experience has been that this is a high performing way of transferring data from Oracle into Teradata.



     
  <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: 27 Dec 2016