- Data Warehousing Architecture.
- What is Star Schema and Snow Flake Schema and their differences.
- What is Dimension Table and types of Dimension Tables.
- Give the example for the fallowing Dimensions: 1)Conformed 2)Degenerate 3)Junk 4)SCD
- What is Fact Table and its types.
- What is Fact less Fact Table and give one example.
- What is ODS and its benefits.
- What is Data Mart.
- What are the approaches of Data Warehouse.