Interested to Buy Any Domain ? << Click Here >> for more details...
Why Multiload does not supports USI and supports NUSI?
- 4 Answers
- 21488 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinay
Index subtable row is on the same Amp as the datarow in
NUSI.so it operates each Amp independently and in parallel.
You can reach me on teradatavinay@yahoo.com
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / yuvaevergreen
Multiload handles every amp independently and parallely.
In case of USI, the index subtable would be present on
different amp which would necessiate the communication of
amps. But in case of NUSI, the imdex subtable would be
present in the same amp having the data row which allows
the mload to handles the amp independently. This is the
reason for supporting NUSI.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / reddy
MulitLoad has support for Non-Unique Secondary Indexes
(NUSIs) since NUSIs are AMP Local. They have subtable
within base table. It has no hash bucket to redirect to
another amp, everything points to their own amp (AMP Local)
If you go with USI, it has hash bucket, which might
redirect to another amp, more possibilites for full table
scan.
Motive for avoiding Indexes(other thn NUSI): Avoid Full
table scan. whenever we define a SI an SI subtable is
created in each AMP.For USI they go for a hash
distribution, and hence the actual data row pointed by the
USI subtable rows in one AMP may not be in the same AMP as
the subtable..so the AMPs
have to communicate, which is not supported by Multiload.
For NUSI the subtable will store references of only those
actual data rows who exist in the same AMP as the
subtable..they all point to the data in their own
AMP..hence AMPs dont need to communicate here.
Thus the AMPs work in parallal with NUSI and hence Mload
supports that.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tdguy
USI involves multi amp communication whereas NUSI is amp
local. Due to this reason, Mload supports NUSI.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is real time and near real time data warehousing?
if a error occured in FASTLOAD is the fastload job stops?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the various etl tools in the market?
How is the teradata different from oracle?
in teradata level primary in table level allows duplicates why?
how do you handle ET and UV errors ?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is partitioned primary index (ppi)?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Teradata 
