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 do high confidence, low confidence and no confidence mean in explain plan?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
List out teradata data types?
What is the command in bteq to check for session settings ?
Highlight the points of differences between the database and user in Teradata.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain how spool space is used.
How to select first n records in teradata?
What is teradata and why it is used?
What is a level of granularity of a fact table?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain teradata architecture?
Highlight the differences between Primary Key and Primary Index.
How to eliminate product joins in a teradata sql query?
Explain fallback in teradata?
