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
Explain the term 'tables' related to relational database management system?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is meant by a Channel Driver?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the functions performed by bynet?
In Teradata, what is the significance of UPSERT command?
What are the joins in teradata and how many types of joins are there in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
How many codd's rules are satisfied by teradata database?
What is primary index and secondary index?
what are the uses of fact table and dimension table in banking project?
What does sleep function does in fast load?
What are the enhanced features in teradata v2r5 and v2r6?
What is meant by a node?
What are the various reporting tools in the market?