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.

Explain Teradata performance tuning and optimization?

1106

---

Difference between multiload and tpump?

1039

---

What are the enhanced features in teradata v2r5 and v2r6?

1078

---

What do you mean by teradata sql assistant?

999

---

What is spool space? Why do you get spool space errors?

947

---

What are default access rights in teradata?

1051

---

What tools would you use for that?

1027

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

928

---

Write a program to show the parser component used in teradata?

913

---

What is node? How many nodes and amps used in your previous project?

1061

---

What are the main components of teradata system?

1066

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1997

---

What are the uses of bynets in multi-node systems?

968

---

Highlight all the modes that are present under Confidence Level.

916

---

What is meant by a Highest Cost Plan?

988

---