how teradata fetches a row from primary index table?
- 1 Answers
- 3138 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 meant by Teradata Gateway?
Explain the teradata primary index mechanics in detail with a diagram.
What is Difference b/w PI & PPI?how to implement PPI?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
In Teradata, what is the significance of UPSERT command?
What is multi insert?
What are the advantages of teradata?
Did you write stored procedures 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?PLZ GIVE ME A EXAMPLE.
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
Explain the advantages of partitioned primary index in a query?
Teradata 
