Answer Posted / 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.

How to select first n records in teradata?

1088

---

Can we collect statistics on table level?

1017

---

What is the difference between teradata and basic rdbms?

1004

---

What does sleep function does in fast load?

1121

---

What are the multiload utility limitations?

1043

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1089

---

What is teradata? Also, list out some of the primary characteristics of teradata.

1045

---

What are the functions of a teradata dba?

1066

---

Explain fallback in teradata?

1038

---

What is the purpose of joins in teradata and what are the available join types?

1060

---

What are different table types used in teradata?

1028

---

What are the enhanced features in teradata v2r5 and v2r6?

1117

---

How is the teradata different from oracle?

1088

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1766

---

What is the purpose of using case expression in teradata?

1000

---