Aggregate table contains the summary of existing warehouse data which is grouped to certain levels of dimensions.
It is always easy to retrieve data from aggregated tables than visiting original table which has million records.
Aggregate tables reduces the load in the database server and increases the performance of the query and can retrieve the result quickly.
No comments:
Post a Comment