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 primary index and secondary index?
What are the functions performed by bynet?
What are the different functions performed in development phase?
Which is faster fastload or multiload?
What is stored procedure in teradata?
How can bottlenecks be identified?
What is the difference between fastload and multiload?
Did you write stored procedures in teradata?
Explain the new features of teradata?
What is difference between user and database in teradata?
What is a clique?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What does Amp contain and what are all the operations that it performs?
What are the updated features of teradata?
