Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 07 Oct 2004 @ 08:21:27 GMT


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


Subj:   ETL Load and upsert
 
From:   Siddhartha Raghuraj Hattangadi

Hi,

We are using Informatica ETL to load a Teradata Box. The architecture demands rows to be upserted into the database. Obviously we have two approaches viz. Relational Update Else Insert or MLOAD upsert.

We know that upsert loader is very fast and are satisfied with it. Our concern is the amount of resources a loader consumes versus a sequence of relational statements. Can anyone put light on same.


Thanks,

Sid



     
  <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