Data Warehousing Question:
Download Questions 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 .

Download Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext 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.