Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2008 @ 11:26:51 GMT


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


Subj:   Re: Reduce loading time
 
From:   OmerAl

Thanks Najam for your reply.

1. I checked the table SKEW and out of 30 tables the maximum SKEW is 8. So I think that rules out the possibility of SKEW being the factor.

2. We only have SET tables and there is no NUPI set on any of the tables.

3. I was thinking of using TPUMP because some of tables have only 300-400 rows. That might reduce the time for some of the tables because MLOAD takes more resources. Not sure about this though.


How many LOAD jobs is a good count? Like we are running approximately 8-10 LOADER jobs at the same time (in parallel). We have a single node 7 AMP machine. Could it be too many LOAD jobs running at the same time?

Appreciate your response.


Regards,

Omer Alvi



     
  <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: 15 Jun 2023