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

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1280


What are the available primary index types?

718


What are the different softwares used with their functions in teradata?

575


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

630


What is upsert statement in teradata?

613






What is the difference between fastload and multiload?

798


What is the difference between union and union all in teradata?

622


What are tpump utility limitations?

596


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3912


what are the uses of fact table and dimension table in banking project?

4102


Highlight all the modes that are present under Confidence Level.

539


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

537


Differentiate database data and data warehouse data?

587


How to find duplicates in a table?

610


Describe the set operators in teradata.

583