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.

Define views in teradata with general syntax.

0 Answers  

---

What is TPD?

0 Answers  

---

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

4 Answers   IBM,

---

What is real time and near real time data warehousing?

0 Answers  

---

can we load 10 millions of records into target table by using tpump?

1 Answers   HP,

---

What is a sparse index?

0 Answers  

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  

---

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

2 Answers   IBM, Wipro,

---

What is logical data model?

0 Answers  

---

what is identity columns in TD?

2 Answers   Wipro,

---

Aborted in Phase 2 data acquistion completed in fastload?

2 Answers  

---