Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Jan 2002 @ 17:13:47 GMT


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


Subj:   Re: How to use Informatica and Teradata support tools for DW
 
From:   Dave Ahnell

Just use your ETL tools to do the extraction and cleansing and have them generate load-ready flat files in a load staging area. Then use FastLoad and/or Multiload to load these files to the database. You're right the Teradata load utilities will handle this much faster.

You can use an enterprise scheduling tool like AutoSys to pull all of this together so that the database load processes are tied to the completion of the ETL processes as well.



     
  <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