Why Multiload does not supports USI and supports NUSI?
- 4 Answers
- 19701 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 |
Why MLOAD needs Work Tables?
What can be achieved by using the teradata rdbms?
what is the difference between start schma and Fsldm?
suppose one Cylinder split data blocks are moved from where?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
How do you create tables? Exact syntax, and create profiles, users in teradata?
any one answer me how they can analyzing the project using data ware housing?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
How can bottlenecks be identified?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are some commonly used bteq scripts?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Teradata 
