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.

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers  

---

What is the default join strategy in Teradata???

5 Answers   IBM,

---

Explain teradata utilities?

0 Answers  

---

What are the advantages of teradata?

0 Answers  

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

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

0 Answers  

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

0 Answers  

---

How to Extract data from multiple legacy systems?

0 Answers  

---

how many modules are there in telecome domain?how to explain the architecture?

0 Answers  

---

What are the multiload utility limitations?

0 Answers  

---

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

---

What is the maximum number of dml can be coded in a multiload script?

0 Answers  

---