1.

What are common aggregate functions? Why do we use aggregate tables in DW?

Answer»

Common aggregate functions include −

  • Average()
  • Count()
  • Maximum()
  • Median()
  • Minimum()
  • Mode()
  • Sum()

These aggregate tables are used for performance optimization to run complex queries in a Data Warehouse.


Discussion

No Comment Found

Related InterviewSolutions