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

About

Sitemap Contact Us

Services

Copyright @Aroha Technologies