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
In the Primary Index, what is the score of AMPs that are actively involved?
Difference between stored procedure and macro?
What is logical data model?
Where is teradata rdbms used?
How to identify ppi columns?
How to find duplicates in a table?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by Teradata Gateway?
Explain the parallel data extension in teradata?
How will you solve the problem that occurs during update?
What is teradata?
Why is the case expression used in teradata?
What are the different softwares used with their functions in teradata?
