Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 02 Mar 2008 @ 09:21:58 GMT

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

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.


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: 28 Jun 2020