Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Jan 2007 @ 17:57:28 GMT


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


Subj:   Multiload Upsert Performance.
 
From:   Barner Eric

I have a general question about Multiload Upsert Performance.

We are considering utilizing Multiload Upserts for the load strategy into many tables in a new subject area of the data warehouse.

We only consider this due to a reduction in complexity for Audits and Control processes. Basically to cheat on the development time up front In order to shorten our time to production.

My reservation is performance degradation over time as the tables grow (some will grow rapidly, 100's of thousands of records per day).

The file from the source system would be many million rows Mixture up updates and inserts, Primarily Updates.

My question has anyone experienced significant detrimental performance impacts, after utilizing this type of load strategy.

Any opinions , lessons learned, or friendly advice would be a great help in the decision of whether or not to implement this load strategy for Large, rapidly growing tables.


Regards,

Eric W. Barner
Senior Teradata DBA
HCA Information Technology & Services



     
  <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