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.

What's the difference between timestamp (0) and timestamp (6)?

1251

---

List the logical and conditional operators that are used with teradata along with their meanings?

1039

---

What are some primary characteristics of teradata?

1050

---

What is meant by a dispatcher?

1062

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1317

---

How is the teradata different from oracle?

1164

---

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

1088

---

What are the components provided on node?

1089

---

What is teradata? What are some primary characteristics of teradata?

1026

---

What is a sparse index?

1119

---

Explain the new features of teradata?

1090

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1123

---

What is the multi-insert?

1082

---

Explain fastload in teradata?

1144

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2912

---