Basics Data Warehouse Interview Questions

 
1.
Explain Differences between star and snowflake schemas?
2.
Explain the data type of the surrogate key?
3.
What is a CUBE in datawarehousing concept?
4.
Explain Why fact table is in normal form?
5.
Explain What are the possible data marts in Retail sales?
6.
Explain degenerate dimension table?
7.
Explain hybrid slowly changing dimension?
8.
Explain conformed fact?
9.
Explain BUS Schema?
10.
Explain What are the advantages data mining over traditional approaches?
11.
Explain Difference between E-R Modeling and Dimentional Modeling?
12.
What is a Fact, Dimension, Measure?
13.
What is Data warehosuing Hierarchy?
14.
Explain What are the steps to build the data warehouse?
15.
Explain ER Diagram?
16.
what is junk dimension?
what is the difference between junk dimension and degenerated dimension?
17.
Explain What are the different types of data warehousing?
18.
Explain Dimensional Modelling?
19.
Explain can a dimension table contains numeric values?
20.
Explain the difference between view and materialized view?
21.
Explain VLDB?
22.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
23.
Explain What are the methodologies of Data Warehousing?
24.
Explain Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
25.
Explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
26.
Explain What is the main difference between Inmon and Kimball philosophies of data warehousing?
27.
Explain a linked cube?
28.
What is the main difference between schema in RDBMS and schemas in DataWarehouse?
29.
What is static and local variable?
30.
What is metadata in context of a Datawarehouse and how it is important?
31.
Suggest a good author for Hyperion in data warehousing?
32.
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?
33.
What is the datatype of the surrogate key?
34.
What is surrogate key? where we use it explain with example?
35.
Explain the definition of normalized and denormalized view and what are the differences between them?
36.
Explain What are the vaious ETL tools in the Market?
37.
What are the Data Marts?
38.
Explain Differences between star and snowflake schemas?
39.
Explain the data type of the surrogate key?
40.
What is a CUBE in datawarehousing concept?
41.
Explain Why fact table is in normal form?
42.
Explain What are the possible data marts in Retail sales?
43.
Explain degenerate dimension table?
44.
Explain hybrid slowly changing dimension?
45.
Explain conformed fact?
46.
Explain BUS Schema?
47.
Explain What are the advantages data mining over traditional approaches?
48.
Explain Difference between E-R Modeling and Dimentional Modeling?
49.
What is a Fact, Dimension, Measure?
50.
What is Data warehosuing Hierarchy?
51.
Explain What are the steps to build the data warehouse?
52.
Explain ER Diagram?
53.
what is junk dimension?
what is the difference between junk dimension and degenerated dimension?
54.
Explain What are the different types of data warehousing?
55.
Explain Dimensional Modelling?
56.
Explain can a dimension table contains numeric values?
57.
Explain the difference between view and materialized view?
58.
Explain VLDB?
59.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
60.
Explain What are the methodologies of Data Warehousing?
61.
Explain Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
62.
Explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
63.
Explain What is the main difference between Inmon and Kimball philosophies of data warehousing?
64.
Explain a linked cube?
65.
What is the main difference between schema in RDBMS and schemas in DataWarehouse?
66.
What is static and local variable?
67.
What is metadata in context of a Datawarehouse and how it is important?
68.
Suggest a good author for Hyperion in data warehousing?
69.
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?
70.
What is the datatype of the surrogate key?
71.
What is surrogate key? where we use it explain with example?
72.
Explain the definition of normalized and denormalized view and what are the differences between them?
73.
Explain What are the vaious ETL tools in the Market?
74.
What are the Data Marts?