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


Please Help Members By Posting Answers For Below Questions

What is real time and near real time data warehousing?

662


What are the components used in smp and massively parallel processing (mpp) machines?

586


What is meant by a Parsing Engine?

697


While creating table my dba has fallback or no fallback in his ddl. What is that?

677


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

646






how can we analyze the locks ?

1693


any one answer me how they can analyzing the project using data ware housing?

2020


What are the different table types supported by teradata?

521


What is primary index and secondary index?

559


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1491


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2990


What are the functions of a Parser?

600


What is a level of granularity of a fact table?

635


What is the difference between global temporary tables and volatile temporary tables?

627


What is the basic syntax for teradata select statement?

569