Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2008 @ 10:41:46 GMT

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

Hi Omer,

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.

Regards

Najam

PS: Tpump is best for real time loading not for daily bulk loading.

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