Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of indexes?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are teradata utilities?
What are the functions involved in shared information architecture?
any one answer me how they can analyzing the project using data ware housing?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain the meaning of Amp?
What happens in a conflict? How do you handle that?
Explain the term 'row' related to relational database management system?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain parsing engine in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the uses of client software involved in teradata?
How do you define Teradata?
