Enterprise Data Warehouse Interview Questions And Answers
Enterprise Data Warehouse Frequently Asked Questions in various Enterprise Data Warehouse Interviews asked by the interviewer. So learn Enterprise Data Warehouse with the help of this Enterprise Data Warehouse Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Enterprise Data Warehouse Interview Question or answer by the comment feature available on the page.
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?
- Ads By Google