Enterprise Data Warehouse Interview Questions

 
1.
Explain What is the data type of the surrogate key?
2.
What a static and local variable?
3.
What is data type of the surrogate key?
4.
Explain difference between view and materialized view?
5.
Explain the main difference between Inmon and Kimball philosophies of data warehousing?
6.
Why fact table is in a normal form?
7.
Explain What are Fact, Dimension, and Measure?
8.
Explain What is a cube in data warehousing concept?
9.
Explain the different types of data warehousing?
10.
What are the main steps to build the data warehouse?
11.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
12.
Explain the main differences between star and snowflake schema?
13.
Explain What is the advantages data mining over traditional approaches?
14.
Explain What is the data type of the surrogate key?
15.
What a static and local variable?
16.
What is data type of the surrogate key?
17.
Explain difference between view and materialized view?
18.
Explain the main difference between Inmon and Kimball philosophies of data warehousing?
19.
Why fact table is in a normal form?
20.
Explain What are Fact, Dimension, and Measure?
21.
Explain What is a cube in data warehousing concept?
22.
Explain the different types of data warehousing?
23.
What are the main steps to build the data warehouse?
24.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
25.
Explain the main differences between star and snowflake schema?
26.
Explain What is the advantages data mining over traditional approaches?