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 is MLOAD Client System restarted after execution?
What is the primary index in teradata?
What is teradata? What are some primary characteristics of teradata?
What are the things to be considered while creating secondary index?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Steps to create a data model?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How is MLOAD Teradata Server restarted after execution?
What are the 5 phases in a multiload utility?
Highlight all the modes that are present under Confidence Level.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How will you solve the problem that occurs during update?
Why managing the data is important?
What is the maximum number of dml can be coded in a multiload script?