More Data Warehousing Interview Questions

WHAT DO YOU MEAN BY DATA WAREHOUSE OR DATA WAREHOUSING?
2 WHAT IS THE DIFFERENCE BETWEEN DATA WAREHOUSE AND TRANSACTIONAL SYSTEM?
3 WHAT IS DIMENSIONAL MODEL HOW IT IS DIFFERENT THAN ER MODEL?
4 WHAT IS THE DIFFERENCE BETWEEN OLAP AND OLTP?
5 WHAT IS ODS?
6 WHAT IS THE DIFFERENCE BETWEEN ODS AND DATA WAREHOUSE?
7 WHAT IS DATA MART?
8 WHAT IS THE DIFFERENCE BETWEEN DATA MART AND DATA WAREHOUSE?
9 WHAT ARE THE GOALS OF DATA WAREHOUSE?
10 WHY DO WE NEED DATA WAREHOUSE OR WHAT’S THE PURPOSE OF DATA WAREHOUSE?
11 WHAT ARE THE CHALLENGES AND ISSUES OF DATA WAREHOUSE?
12 WHAT ARE THE DIFFERENT ARCHITECTURAL COMPONENTS OF DATA WAREHOUSE?
13 WHAT IS DIFFERENCE BETWEEN BUSINESS INTELLIGENCE AND DATA WAREHOUSING?
14 WHAT IS METADATA?
15 WHAT IS FACT TABLE?
16 WHAT IS DIMENSION TABLE?
17 WHAT DO YOU MEAN BY GRANULARITY OF FACT OR GRAIN?
18 WHAT IS AGGREGATE TABLE?
19 EXPLAIN DIFFERENT TYPES OF DIMENSIONAL MODEL?
20 WHAT ARE THE DIFFERENT ARCHITECTURAL CHOICES AVAILABLE IN DIMENSIONAL MODELING?
21 CAN YOU EXPLAIN THE GENERAL DATA MODELING LIFECYCLE?
22 CAN YOU EXPLAIN THE DIMENSIONAL DATA MODELING LIFECYCLE?
23 WHEN SHOULD WE CREATE SEPARATE FACT TABLES?
24 WHAT IS DEGENERATE DIMENSION?
25 CAN’T WE STORE DEGENERATE DIMENSION IN DIMENSIONS TABLE INSTEAD OF FACT TABLE?
26 WHAT IS HIERARCHY AND HOW IT IS HANDLED IN DIMENSIONAL MODEL?
27 WHAT ARE SLOWLY CHANGING DIMENSIONS?
28 WHAT ARE FAST CHANGING DIMENSIONS?
29 WHAT IS SNOWFLAKING AND WHEN DO YOU SNOWFLAKE AND WHEN NOT?
30 WHAT ARE GARBAGE DIMENSIONS?
31 WHAT ARE ROLE PLAYING DIMENSIONS?
32 WHAT ARE MULTI-VALUED DIMENSIONS?
33 WHAT ARE HOT SWAPPABLE DIMENSIONS?
34 WHAT IS LOOKUP TABLE IN DIMENSION MODEL?
35 WHAT IS SURROGATE KEY AND WHAT IS ITS SIGNIFICANCE IN DATA WAREHOUSE?
36 WHAT DO YOU MEAN BY GRANULARITY OF FACT TABLE?
37 WHAT IS NON-ADDITIVE FACT?
38 WHAT IS FACT-LESS-FACT TABLE AND WHICH SCENARIO YOU USE IT?