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 to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Highlight the points of differences between the database and user in Teradata.
Why managing the data is important?
What is the primary index in teradata?
Difference between inner join and outer join?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the functions of a teradata dba?
What is the purpose of joins in teradata and what are the available join types?
What is TPD?
Explain fastload in teradata?
What are the 5 phases in a multiload utility?
What are the different methods ot loading a dimension table? A fact table etc?
What are different table types used in teradata?
What are the available primary index types in teradata.
How do you do backup and recovery in teradata?