Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2008 @ 10:41:46 GMT
There can be two possible reasons, which may effect loading time.
1- Table skewness, check the skew factor for each table and if its high its mean data is not equally distributed to all Amps, as a result effect the loading time. The solution for this is Primary index revision.
2- Duplicate row check which is very resource extensive, it usually occur when you have NUPI on the table but table type is set, so at each insertion all fields of every row need to be checked to avoid duplication, the solution for this issue is to change the table type to multiset.
Hope above information will help you.
PS: Tpump is best for real time loading not for daily bulk loading.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|