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 some commonly used bteq scripts?
What is the difference between union and union all in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the use of virtual processor connectivity in teradata?
Why does varchar occupy 2 extra bytes?
What is the purpose of joins in teradata?
What are the things to be considered while creating secondary index?
What happens in a conflict? How do you handle that?
Describe primary index in teradata. And what are the available primary index types?
How will you solve the problem that occurs during update?
How can you track login parameters of users in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is a three-tier data warehouse?
Explain the term 'tables' related to relational database management system?
What is the purpose of upsert command?
