DATA WAREHOUSING CONCEPTS

DATA WAREHOUSING CONCEPTS

1.         What is a data-warehouse?

2.         What is Dimensional Modeling?

3.         What is the Difference between OLTP and OLAP?

4.         What is Fact table and dimension table?

5.         What is a level of Granularity of a fact table? What does this signify?

6.         What are slowly changing dimensions? What are SCD1, SCD2 and SCD3?

7.         What are types of facts? (Inventory, Account balances in bank)

8.         What are conformed dimensions?

9.         Discuss the advantages & Disadvantages of star & snowflake schema?

10.       What is a junk dimension?

11.       What are the difference between view and materialized view?

12.       Compare Data Warehousing Top-Down approach with Bottom-up approach

13.       What is fact less fact table?

14.       What is the architecture of any Data warehousing project? What is the flow?

15.       Where we use Star Schema & where Snowflake?

16.       Tell me what would the size of your warehouse project?

17.       What is surrogate key? Where we use it explain with examples

18.       Can a dimension table contain numeric values?

19.       What is Difference between E-R Modeling and Dimensional Modeling?

20.       Why fact table is in normal form?

21.       What is the role of surrogate keys in data warehouse and how will u generate them?

22.       What is the main difference between Inmon and Kimball philosophies of data warehousing?

23.       How do you connect two fact tables? Is it possible?

24.       What is data cleansing? How is it done?

25.       Difference between DWH and ODS?