Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
Answer Posted / subbu
Hi,
Though in case of NUSI the subtable rowid and base table
rowid will be on same AMP,FLOAD doesn't support the multi
AMP communication and even the NUSI contains dupliate
values aswell so either of these are not supported by FLOAD.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is real time and near real time data warehousing?
What are the components used in smp and massively parallel processing (mpp) machines?
What is meant by a Parsing Engine?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
how can we analyze the locks ?
any one answer me how they can analyzing the project using data ware housing?
What are the different table types supported by teradata?
What is primary index and secondary index?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the functions of a Parser?
What is a level of granularity of a fact table?
What is the difference between global temporary tables and volatile temporary tables?
What is the basic syntax for teradata select statement?