Data Warehousing Question: Download Data Warehousing PDF
What is the difference between aggregate table and materialized view?
Answer:
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 .
| Previous Question | Next Question |
| What is the difference between OLAP and OLTP? | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |