Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Jan 2012 @ 22:51:17 GMT


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


Subj:   Table skewed on load
 
From:   Issah, Gabriel

I have a table that whenever I start to load data into it. My AMPs run very high or It consumes a lot of AMPs. I am doing a straight load.

I am using an etl tool

     select * from tableA and insert it into tableB.

The table has been cleanse and it loads fast but my Amps way high.


Gabriel Issah
Infrastructure Oversight Analyst LTCP HIA? MCITP Information Technology Senior Health
Insurance of Pennsylvania



     
  <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