DATA WAREHOUSE FUNDAMENTALS
An introduction to Data Warehousing
Purpose of Data Warehouse
Data Warehouse Architecture
Operational Data Store
OLTP Vs Warehouse Applications
Data Marts
Data marts Vs Data Warehouses
Data Warehouse Life cycle.
DATA MODELING
Introduction to Data Modeling
Entity Relationship model (E-R model)
Data Modeling for Data Warehouse, Normalization process
Dimensions and fact tables
Star Schema and Snowflake Schemas.
ETL DESIGN PROCESS
|
||||||||||||
