Data Warehousing Interview Question:

What is the difference between aggregate table and materialized view?

Submitted by: Administrator

Aggregate tables are pre-computed totals in the form of hierarchical multidimensional structure., whereas materialized view ,is an database object which caches the query result in a concrete table and updates it from the original database table from time to time .Aggregate tables are used to speed up the query computing whereas materialized view speed up the data retrieval .
Submitted by: Administrator