Archives of the TeradataForum
Message Posted: Tue, 10 Jan 2012 @ 22:51:17 GMT
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
|