Answer Posted / rahul

Amp is a virtual process, it performs dml,ddl operations
and also responsible for applying and releasing locks.
amp having some space to perform operations,like storing the
data.
this space can not be shares any other amp in the node.
dats y we call Teradata architecture is shared nothing.

amps are associated with disk,which will invokes controllers
of the disk after completion of its task.


Thanks
Rahul

How to select first n records in teradata?

1082

---

How is the teradata different from oracle?

1082

---

What is smp and mpp platforms?

958

---

How to eliminate product joins in a teradata sql query?

998

---

How do you determine the number of sessions?

1047

---

How do you verify a complicated sql?

1050

---

What do you mean by teradata intelliflex?

1077

---

Explain teradata utilities. What is multiload, fast load, tpump?

992

---

What is logical data model?

1187

---

How do you set the session mode parameters in bteq?

1088

---

What is partitioned primary index (ppi)?

1040

---

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

978

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

970

---

if collect stats but it show low confidence why?

1673

---

What are the various etl tools in the market?

1061

---