Data Warehouse Interview Questions

1. What is the data type of the surrogate key?
2. What are the steps to build the data warehouse?
3. What are the different architectures of data warehouse?
4. What are the advantages data mining over traditional approaches?
5. What is the difference between view and materialized view?
6. What is the main difference between Inmon and Kimball philosophies of data warehousing?
7. What is junk dimension? what is the difference between junk dimension and degenerated dimension?