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 are the different softwares used with their functions in teradata?
What are the various indexes in teradata?
Which is more efficient group by or distinct to find duplicates?
Explain the term 'primary key' related to relational database management system?
What are the steps to create a data model?
What is collect statistics?
What is meant by a dispatcher?
How many codd's rules are satisfied by teradata database?
What are the newly developed features of Teradata?
Explain the term 'foreign key' related to relational database management system?
What is the function of parser component in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
Can you connect multiload from ab initio?
How would you load a very large file in teradata in general?
What are the string manipulation operators and functions associated with teradata?
