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

Please explain in this regard.

Thanks in advance.




Answers were Sorted based on User's Feedback



Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this rega..

Answer / hari m

quoted points absolutely correct. i.e,
FAST LOAD does not support duplicate records...and it does
not support SI,JI,RI,HI because these require communication
between AMP's

I feel the posted ans is still not appropriate!

NUSI concept is same for even fload, as stated above in
NUSI subtable exists in the same amp so mload supports.
then why fload does not supports??

Now I guess my question more clear!!

Is This Answer Correct ?    2 Yes 0 No

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this rega..

Answer / 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

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this rega..

Answer / 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




Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this rega..

Answer / kishore

FAST LOAD does not support duplicate records...and it does not support SI,JI,RI,HI because these require communication between AMP's....and MLOAD supports NUSI because in NUSI subtable exists in the same amp so it supports.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer



More Teradata Interview Questions

What happens in a conflict? How do you handle that?

0 Answers  


What is meant by a node?

0 Answers  


What is bteq utility in teradata?

0 Answers  


What are the different methods ot loading a dimension table? A fact table etc?

0 Answers  


What do high confidence, low confidence and no confidence mean in explain plan?

0 Answers  






How to run the Teradata jobs in unix environment ???

4 Answers   IBM,


What are the uses of client software involved in teradata?

0 Answers  


What is the purpose of indexes?

0 Answers  


What are the frequently used data types in teradata?

0 Answers  


Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers  


How to view every column and the columns contained in indexes in teradata?

0 Answers  






Categories