Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frinds pls help me regarding this question
WHY usi is two amp operation in teradata?
THANKS IN ADVANCE....
- 3 Answers
- 7036 Views
- I also Faced
- E-Mail Answers
Answer Posted / tdguy
When an USI is created, a subtable is generated and stored.
When that USI is used in the query,TD recognizes the USI.
TD will hash the SI and the hash map will point to the
subtable in one AMP. The subtable row will point the row-id
and the row is fetched from the second amp.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the joins in teradata?
Highlight the limitations of TPUMP Utility.
What are the string manipulation operators and functions associated with teradata?
Why managing the data is important?
In Teradata, what is the significance of UPSERT command?
What are the various indexes in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is a dimension table?
What is partitioned primary index (ppi)?
What is meant by a Virtual Disk?
Explain teradata architecture?
What are the various indexes in teradata? How to use them?
How do you verify a complicated sql?
Highlight the differences between Primary Key and Primary Index.
What is a sparse index?
