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.

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,

---

what is the difference between bpo and call centre?

2 Answers   American Solutions,

---

What do you mean by teradata sql assistant?

0 Answers  

---

What is dimensional modeling?

0 Answers  

---

Explain some differences between mpp and smp?

0 Answers  

---

How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  

---

what is meant by Hot amp?

2 Answers   IBM, Satyam,

---

Highlight the points of differences between the database and user in Teradata.

0 Answers  

---

What is the meaning of Caching in Teradata?

0 Answers  

---

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---