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.

Syntax for case when statement?

1069

---

List out all forms of LOCKS that are available in Teradata.

969

---

Why are oltp database designs not generally a good idea for a data warehouse?

1056

---

What is multi insert?

1056

---

Differentiate primary key and partition key?

983

---

How to eliminate product joins in a teradata sql query?

1035

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1168

---

What are some commonly used bteq scripts?

1012

---

Why teradata is used?

1011

---

Different phases of multiload?

1019

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1186

---

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

1022

---

Describe primary index in teradata. And what are the available primary index types?

1004

---

What are some primary characteristics of teradata?

1002

---

What is the purpose of upsert command?

1178

---