Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Nov 2006 @ 22:48:09 GMT


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


Subj:   Performance Tips for SQLPLUS / Named Pipes /
 
From:   Cox, David

We have built a datamart on our Teradata server that is primarily sourced from an Oracle database.

We are well satisfied with the datamart and want to put the ETL process into production. To do this, we need to move to using Oracle Sqlplus code that is run from Korn shells. The data passes through a named pipe on it's way to the Teradata fastload utlility. We will perform full table copies from the Oracle database The ETL is a full table copy from Oracle to Teradata.

Performance of the ETL process described above is slower than we had anticipated. We are having trouble seeing where the performance hit is occuring. Has anyone else had experience using an ETL process that involves Sqlplus / Korn scripts / named pipes / Fastload? Can you give us any advice on tuning this?


Thanks.

David A. Cox
Business Intelligence Analyst



     
  <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