how teradata fetches a row from primary index table?
- 1 Answers
- 3331 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 partitioned primary index (ppi)?
Why does varchar occupy 2 extra bytes?
Describe the between keyword in teradata?
If table have access lock.In the same table write lock is posible or not?
if a error occured in FASTLOAD is the fastload job stops?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain fastload in teradata?
How to identify ppi columns?
What is the difference between fastload and multiload? Which one is faster?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Explain the most common data types used in teradata?
Teradata 
