Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Jan 2002 @ 09:34:40 GMT


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


Subj:   How to use Informatica and Teradata support tools for DW
 
From:   Rohit Revo

In a typical Data Warehousing environment, it is likely that we use ETL tools like Informatica, SAS, etc for extraction and cleansing and then using some Teradata utility like FastLoad or MultiLoad. While the data load from ETL tools like Informatica, SAS is done using ODBC, it is quite slow in execution as compared to Teradata utilities like FastLoad and MultiLoad which load data in parallel.

Use of Informatica/SAS is must as we need to extract and cleanse data frst before loading. So if we use Informatica or any other tool for extraction and then use Teradata utilities for loading, this may be the fastest solution.

Can anyone elaborate on how to use Informatica or any other ETL for extraction and cleansing while using Teradata utilities for loading in a Data Warehousing environment.


Regards

ROHIT REVO



     
  <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