Answer Posted / hrith

Hi please send to thahirmd@yahoo.co.in ... thanks

Discuss the advantages of using partitioned primary index in a query?

997

---

What are types of partition primary index (ppi) in teradata?

1100

---

Highlight the need for Performance Tuning.

1152

---

What are the updated features of teradata?

1088

---

What do you mean by fastexport in teradata?

1042

---

Explain the teradata primary index mechanics in detail with a diagram.

1034

---

what is object level locking ? where do appear this type of locking ?

3537

---

How will you solve the problem that occurs during update?

1101

---

What are the different table types that are supported by teradata?

1048

---

How to select first n records in teradata?

1159

---

What is meant by a Parsing Engine?

1233

---

What are the different methods ot loading a dimension table? A fact table etc?

1079

---

how do you manage the production space. what are the proactive methods you can take ?

1978

---

What do high confidence, low confidence and no confidence mean in explain plan?

1097

---

What are the components used in smp and massively parallel processing (mpp) machines?

1093

---