Interview Questions   Tutorials   Discussions   Programs   

Teradata - Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?




1780
views
asked mar September 20, 2014 06:38 AM  

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?


           

1 Answers



 
answered By vishnoiprem   0  
Whenever we define a Secondary index, an Secondary index subtable will be created.In case of UPI, when they go for has distribution subtable is in one AMP and actual data row pointed by USI subtable is in another AMP. So the AMPs need to communicate, which is not supported by Multiload. But in case of NUSI, the subtable and the references of the actual data will store in the same AMP hence AMPs no need to communicate here.

So in case of NUSI, AMPs work in parallal and hence Mload supports that.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert