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

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

---

What is the maximum number of dml can be coded in a multiload script?

0 Answers  

---

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

---

Why FLOAD does not support multiset tables??

3 Answers   TCS, Tesco,

---

how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,

---

What are the available join types in teradata?

0 Answers  

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

0 Answers  

---

Explain fastload in teradata?

0 Answers  

---

If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,

---

what is identity columns in TD?

2 Answers   Wipro,

---

Is multi insert ansi standard?

0 Answers  

---

What is the use of stored procedures in teradata?

0 Answers  

---