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
Why managing the data is important?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Did you write stored procedures in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How you will check the version of teradata?
What do you mean by fastexport in teradata?
Different phases of multiload?
How do you do backup and recovery in teradata?
How to view every column and the columns contained in indexes in teradata?
What is the basic syntax for teradata select statement?
How to load specific no.of records using bteq, or fastload,or multiload
Explain parsing engine in teradata?
What are some primary characteristics of teradata?
What are tpump utility limitations?
What do you mean by teradata intelliflex?
