Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2008 @ 12:48:48 GMT


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


Subj:   Re: Reduce loading time
 
From:   william.gregg

Omer - is it possible to use a common file to load multiple tables? MLoad supports this capability.

Consider Multiset, but if U cannot take the pain of duplicates/bad-feeds then U must live with the overhead of SET processing. Perhaps tighter front-end processing may prevent the loading of the wrong files.

Are U only loading new data and updates? Are U completely reloading every table during each run?

U need to consider what is being done that does not have to be done.

- read data once

- exactly one process updates one or more tables


Finally, a 1 node 7 amp box is awfully small for a production box. Consider scaling back to 2-3 simultaneous job streams.

Best of Luck.


Rgrds,

Bill Gregg



     
  <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: 15 Jun 2023