Archives of the TeradataForum
Message Posted: Tue, 10 Jan 2012 @ 23:36:11 GMT
| 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.
| 
