Interview Questions   Tutorials   Discussions   Programs   

Teradata - Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?




748
views
asked mar September 20, 2014 06:37 AM  

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?


           

1 Answers



 
answered By vishnoiprem   0  
Please see the below points:

SI
  • USI - generally stored in sub table in a different amp other
  • than the amp having data row. Both the utilities do not
  • support.
  • NUSI - The sub table is stored in the same amp itself. Mload
  • supports it and Fastload not.
JI
  • TD generally stores the rows of join index across the amps.
  • Both the utilities do not support.
RI and triggers
  • These are multi amp operations and any operation involving
  • communication between two amps is not supported by these
  • two utilities
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