Categories

Oct 20, 2019 in Dataware house
Q: What are Aggregate tables?

1 Answer

Oct 20, 2019

Aggregate tables are the tables which contain the existing warehouse data which has been grouped to certain level of dimensions. It is easy to retrieve data from the aggregated tables than the original table which has more number of records.

This table reduces the load in the database server and increases the performance of the query.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Nov 26 in Sql
Nov 26 in Sql
Mar 23 in SAP
...