Data warehouse
- OLTP System
- Definition of data warehouse
- Difference between ODS AND DWH
- Types of ETL Tools
- Data Extraction
- Data Transformation
- Data Loading
- Types of Data loading
- Data warehouse Approaches
- Top down approach and Bottom up approach
- DW Life cycle
- DW-database design
- Star schema and Snow flake schema
- Dimensional modelling
- Facts and dimensions
- Granularity
- Drill down and Drill up
- Types of Dimensions
- Types of fact tables
- Types of OLAP
- Difference between ETL architecture and ELT architecture
