Data Warehousing Interview Questions

Give the two types of tables involved in producing a star schema and the type of data they hold.

What are types of Facts?

What are non-additive facts in detail?

What is the difference between view and materialized view?

What is active data warehousing?

What is SKAT?

What is Memory Based Reasoning (MBR)?

Give reasons for the growing popularity of Data Mining.

What is Market Basket Analysis?

What is Clustering?

What are cubes?

What are measures?

What are dimensions?

What are fact tables?

What are the benefits of Data Warehousing?