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

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1534


What are the multiload utility limitations?

785


What are the steps involved after the disk manager passes the request?

798


Explain the types of join supports by teradata?

763


Can we collect statistics on multiple columns?

754


Mention a few of the ETL tools that come under Teradata.

835


How many types of joins are there in teradata?

719


How to eliminate product joins in a teradata sql query?

793


Why does varchar occupy 2 extra bytes?

830


List out teradata data types?

746


What is the difference between fastload and multiload? Which one is faster?

869


What are the different table types supported by teradata?

722


Highlight the differences between Primary Key and Primary Index.

814


What are types of partition primary index (ppi) in teradata?

794


Explain vproc in teradata?

757