Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Jan 2012 @ 23:36:11 GMT


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


Subj:   Re: Table skewed on load
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, January 10, 2012 16:27 -->

Using all AMPs is normal (for load or SQL). Please restate what it is that you see as the problem.

At a guess: You are running with no utility session limits (e.g. any release of Teradata prior to 13.10) and getting the default of one session per available AMP for the load utility. In that case, solution is to specify the number of sessions for the load operation in your ETL tool. Details of how to do that depend on the tool.

Even better is to "push down" the INSERT/SELECT to the database and not invoke a load utility at all. Again, whether this is even possible (and if so, how to do it) depends on the specific ETL tool.



     
  <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