 |
 |
Archives of the TeradataForum
Message Posted: Sun, 02 Mar 2008 @ 09:21:58 GMT
| Subj: | | Re: MLOAD application phase |
| |
| From: | | OmerAl |
Hello Dave, Michael, Victor
Thank you all for your replies.
I tried the experiment in the DEV env by setting the table to NUPI and MULTISET. The time difference was just a few minutes and there was
hardly anything running in the DEV environment. So I am guessing that if I habe 2-3 MLOAD jobs running the time would be the same. Also, we cannot
have UV errors because the INFA mapping ensures the key generated is always unique. I just don't understand how this could be reduced. Does it
make a difference to MLOAD if the target table size is huge (my guess is it should not)? Also, like I had said, the EVENT table has 20 fields out
of which 12 are NULL always. Not sure if that is the issue.
Regards,
Omer Alvi
| |
