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.


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: 28 Jun 2020