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
- 7117 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nitin bansal
Generally the Parsing Engine preapres a two amp plan for
USI, as in case of USI there will be a subtable which has
the hashed value of the USI and the ROW ID of the Primary
Index. So when you search using the USI first it will go to
the AMP which has the subtable and then using the ROW id
from the subtable it will go to the AMP where the actual
row resides.
In a case where the PI and USI value are same it can be a
one amp operation as the HASHED value of oth the PI and USI
will go to the same AMP.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gowthami
Thanks alot nitin for ur rly.
i would like share 1 interview question which was asked in
ibm.
Q)there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain teradata architecture in detail with a diagram.
What are two examples of an OLTP environment?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
what is amp plz explanation
How is MLOAD Client System restarted after execution?
which utitility can use for loading the data from non-teradata to teradata ?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
How a Referential integrity is handled in Teradata?
What is a node in teradata?
Why managing the data is important?
What is meant by a Highest Cost Plan?
why should we go Teradata over Oracle,what is the main differences?
Teradata 
