Home
Courses
Contact Us
Log in
Sign Up
Home
Courses
Contact Us
Log in
Sign Up
Home
Courses
Contact Us
Log in
Sign Up
Data Warehouse Concepts
Contents
Before you learn DW
Free Preview
Introduction to DW
Differences Between OLTP And DW
DW Architecture
Definition of DW Part One
Definition of Datawarehouse Part II
Definition of Datawarehouse Part III
Different approaches to build DW
Difference between DW and Data Mart
DW Maturity
Data Granularity
Itroduction to ETL (Extract Transfer and Load)
Extract process in ETL Layer
Extract scenarios in ETL Layer
Transformation process in ETL Layer
Different transformations in ETL
Loading process in ETL Layer
Data Modeling in DW systems
Difference between 3rd NF and Dimensional Modeling
Introduction to Dimensional Modeling
Star and Snowflake schemas
Slowly Changing Dimension - SCD1
Slowly Changing Dimension - SCD2
Slowly Changing Dimension - SCD3
DW Fact table
Assignments
Quiz