Interested to Buy Any Domain ? << Click Here >> for more details...
how teradata fetches a row from primary index table?
- 1 Answers
- 3711 Views
- I also Faced
- E-Mail Answers
Answer / vinoth
All the rows in the table will be evenly disturbed among the AMP's based on the Primary Index column.
Eg. employee table (EMP_NO(PI),EMP_NAME)
AMP1 AMP2 AMP3
12,PARTI 15,alex 14,flex
When you execute the query select emp_name from employee where emp_no='12' .
It's a One AMP operation, it will directly go to AMP 1 and it will fetch the value "PARTI".
Please look at the terms PE, BYNET and AMP to understand this more.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is database exceptions in teradata?
Find 2 highest sal from each dept who have completed 5 year in org
Mention a few of the ETL tools that come under Teradata.
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
Explain teradata architecture?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What is dimensional modeling?
Explain parsing engine in teradata?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
What is the difference between SI and JI?
wt r before journal& after journel.....in teradata
What is the difference between teradata and oracle?
Teradata 
