Email id : [email protected]
What is Data Warehousing?
Differences between OLTP and Data Warehousing
DATA ACQUISITION
DATA EXTRACTION
DATA TRANSFORMATION
DATA LOADING
Data Marts
Dependent DM
Independent DM
Data Warehousing Life Cycle
Database Design
Star Schema
Snowflake Schema
Fact Constellation Schema
SCD (Slowly changing Dimensions)
TYPE1 SCD
TYPE2 SCD
TYPE3 SCD
SAMPLE Loading from source to target
SORTER Transformation
FILTER Transformation
ROUTER Transformation
EXPRESSION Transformation
JOINER Transformation
UNION Transformation
AGGREAGATOR Transformation
RANK Transformation
STORED PROCEDURE Transformation
SEQUENCE GENERATOR Transformation
Flat File
SQL Transformation
Different types of testing techniques in ETL
MINUS Query
COUNT Query