Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Reduce loading time
From:   Saqib, Najam Us

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.



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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019