Archives of the TeradataForum

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

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

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>>