Global Web Forum

AgentVinod12

Agent Vinod

From: India

Registered: 2012-03-23

Posts: 1,149

Website

Enterprise Data Warehouse Interview Questions And Answers

Data Warehouse :: Enterprise Data Warehouse Job Interview Questions and Answers

Enterprise Data Warehouse guideline for job interview preparation. Explore list of Enterprise Data Warehouse frequently asked questions(FAQs) asked in number of Enterprise Data Warehouse interviews. Post your comments as your suggestions, questions and answers on any Enterprise Data Warehouse Interview Question or answer. Ask Enterprise Data Warehouse Question, your question will be answered by our fellow friends.

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?