Archives of the TeradataForum

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

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

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>>