Why FLOAD doesn't supports NUSI? Where as Mload supports
Please explain in this regard.
Thanks in advance.
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
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
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
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..
|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|
How to relege locks in fastload and multiload? example?
what is the difference between primary index and secondary index?.
While creating table my dba has fallback or no fallback in his ddl. What is that?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Give some points about Teradata Viewpoint ?
How to cast date "2015-03-03-012204-000000" to timestamp
What are differences between teradata and ansi session modes in teradata?
what is sysdba and sysdbc ? which has high priority ?
What is meant by a Highest Cost Plan?
Mention a few of the ETL tools that come under Teradata.
How do you Generate Sequence in Teradata?