Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
Answer Posted / kishore
FAST LOAD does not support duplicate records...and it does not support SI,JI,RI,HI because these require communication between AMP's....and MLOAD supports NUSI because in NUSI subtable exists in the same amp so it supports.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How do you verify a complicated sql?
What are the different functions included in the server software?
What are different table types used in teradata?
Comment whether bottleneck is an error or not.
What happens when a node suffers a downfall?
Explain teradata utilities. What is multiload, fast load, tpump?
Describe the between keyword in teradata?
Explain the term 'row' related to relational database management system?
Highlight the limitations of TPUMP Utility.
What is multi insert?
In general, how do you optimze any sql in teradata?
List out all forms of LOCKS that are available in Teradata.
What are the steps involved in the process flow of the sql statement through channel attached system?
Differentiate primary key and partition key?
Define views in teradata with syntax.