Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.

Please explain in this regard.

Thanks in advance.

Answer Posted / santhosh kumar burada

Hi..!!

i think, when we are going for Fload the target table will be
SET table so, that will not support for duplicate values..
in NUSI we have duplicate values, so that will not support..
in Mload target table will be any thing, either SET or Multiset.. so that will support..

Thank you..
Santhosh kumar.B

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the differences between Primary Key and Primary Index.

801


What are the available primary index types in teradata.

764


What is stored procedure in teradata?

762


What are aggregate tables? How do you design them using teradata?

830


Explain the teradata primary index mechanics in detail with a diagram.

737


List the logical and conditional operators that are used with teradata along with their meanings?

739


Which is more efficient group by or distinct to find duplicates?

849


What is the basic syntax for teradata select statement?

757


What is meant by a Virtual Disk?

796


What do you mean by teradata intellicloud?

791


What is meant by a Channel Driver?

834


How many codd's rules are satisfied by teradata database?

858


What is the purpose of using case expression in teradata?

752


Explain teradata vs. Redshift?

727


What is smp and mpp platforms?

703