Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
- 4 Answers
- 14038 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 |
What is differnce between Error code and Error Level in Bteq
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
What is use of compress in terdata?Explain?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
What is the use of upsert command in teradata?
The transaction exceeded the maximum number of rowhash locks allowed
What is teradata and why it is used?
What are types of partition primary index (ppi) in teradata?
Why managing the data is important?
can we join volatile table with general table an global temporary table with general table ?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
Teradata 
