Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2008 @ 11:26:51 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|