Answer / Ashutosh Verma

In Teradata, a dispatcher is a process that manages the flow of work between client applications and AMPs (Active Memory Partitions). The dispatcher splits queries into smaller pieces, known as chunks, and distributes them to the appropriate AMPs for execution.

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

---

What is the basic syntax for teradata select statement?

1 Answers  

---

What is upsert statement in teradata?

1 Answers  

---

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

---

What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,

---

How to Extract data from multiple legacy systems?

1 Answers  

---

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  

---

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 Answers   IBM, Wipro,

---

What are the available primary index types?

1 Answers  

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1 Answers  

---

What is a three-tier data warehouse?

1 Answers  

---

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

1 Answers  

---