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 you will check the version of teradata?

1110

---

What is a sparse index?

1040

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1024

---

Explain the meaning of Amp?

1067

---

Which is faster fastload or multiload?

1061

---

Explain and compare pros and cons of start schemas?

1006

---

Explain the term 'database' related to relational database management system?

948

---

What is spool space?

1102

---

What is the difference between fastload and multiload? Which one is faster?

1170

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

981

---

Explain the advantages of partitioned primary index in a query?

992

---

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

960

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1113

---

How do you do backup and recovery in teradata?

982

---

Highlight the need for Performance Tuning.

1061

---