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


Please Help Members By Posting Answers For Below Questions

How is MLOAD Client System restarted after execution?

691


What is the primary index in teradata?

688


What is teradata? What are some primary characteristics of teradata?

629


What are the things to be considered while creating secondary index?

728


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

456






Steps to create a data model?

758


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

766


How is MLOAD Teradata Server restarted after execution?

755


What are the 5 phases in a multiload utility?

703


Highlight all the modes that are present under Confidence Level.

630


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

681


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

638


How will you solve the problem that occurs during update?

692


Why managing the data is important?

665


What is the maximum number of dml can be coded in a multiload script?

698