Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
- 4 Answers
- 13194 Views
- Teradata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
Why AMP & PE are called Vprocs?
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
Explain the new features of teradata?
What are differences between teradata and ansi session modes in teradata?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
Describe primary index in teradata. And what are the available primary index types?
What is meant by a dispatcher?
What are the things to be considered while creating secondary index?
What is meant by a node?
How many types of index are present in teradata?
Teradata 
