Hi frinds pls help me regarding this question
WHY usi is two amp operation in teradata?
THANKS IN ADVANCE....
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 vs. Redshift?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
Describe primary index in teradata. And what are the available primary index types?
What are the different table types that are supported by teradata?
Is multi insert ansi standard?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Difference between Teradata V2R5 and Teradata V12 versions?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the different methods ot loading a dimension table? A fact table etc?
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
if collect stats but it show low confidence why?