What are aggregate tables? How do you design them using Teradata?

devquora
devquora

Posted On: Feb 22, 2018

 

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions