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
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight the advantages of PPI(Partition Primary Index).
What is basic teradata query language?
Explain teradata utilities. What is multiload, fast load, tpump?
What is the use of fallback?
In Teradata, what is the significance of UPSERT command?
What do you mean by ttu in teradata?
Describe the between keyword in teradata?
How many tables can you join in v2r5?
While creating table my dba has fallback or no fallback in his ddl. What is that?
how can we analyze the locks ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the different functions performed in development phase?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
