Answer / farheen

An aggregate table is those tables which contain the summary of the existing warehouse. It is used to save the time as retrieving data from a million of records in the actual table will take too much time. So, aggregate the tables to a certain level of dimensions and use them.

Teradata supports some aggregate functions which are:

COUNT: It is used to count the rows.
SUM: used to calculate the sum of specified columns.
MIN: To find the minimum value from specified columns.
MAX: to find the maximum value from specified columns
AVG: to calculate the average of specified columns.

what are the day to day activities of teradata DBA ?

0 Answers   TCS,

---

What is the opening step in basic teradata query script?

0 Answers  

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---

how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,

---

what is the default character set in teradata,,?

2 Answers   IBM, TCS,

---

How to relege locks in fastload and multiload? example?

4 Answers   IBM,

---

What is the use of virtual processor connectivity in teradata?

0 Answers  

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  

---

what is DYNAMIC SQL in TD?

1 Answers   IBM,

---

what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,

---

Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,

---

In Teradata, what is the significance of UPSERT command?

0 Answers  

---