Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 15:36:24 GMT


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


Subj:   Loading Fact data directly onto Teradata
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, December 05, 2002 10:22 -->

Hi,

I have been told by some Informatica ETL experts that loading Fact data (Transaction data) in Teradata is slow when we want to apply some transformations on the data.

The faster approach they say is to stage the data in some other database (we have oracle here), apply transformations in the staging and then load the transformed data to Teradata. (We are in the process of moving our warehouse from Oracle to Teradata).

I believe we can do transformations using Teradata Procedures and reduce the extra hop of data.

I need your comments on this issue.

Thanks.



     
  <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