ETL Testing Online Training|Support

[john27]

Best Online Training Providers by Real Time Experts on ETL Testing :

ETL Testing Course Content :

Data Warehouse Concepts

• What is Data Warehouse?

Introduction to Data warehouse Characteristic features of Data warehouse

• Time Variant
• Non-Volatile
• Subject Oriented
• Integrated

Differences between OLTP and OLAP

What is Data Warehousing?

• Design Schema
• ETL – Extraction Transformation & Loading
• Reporting

Data Acquisition

• Data Extraction
• Data Transformation
• Data Cleansing
• Data Scrubbing
• Data Merging
• Data Aggregating
• Data Loading
• Initial Load / Full Load
• Incremental Load / Delta Load

Data Marts

• Top down Approach / Dependent Data Mart
• Bottom up Approach / Independent Data Mart

Dimension Table & Fact Table

Database Design

• Star Schema
• Snow Flake Schema

Slowly Changing Dimensions [SCD]

• SCD Type 1
• SCD Type 2
• SCD Type 3

Phases in Dimensional Modeling

• Conceptual Modeling
• Logical Modeling
• Physical Modeling

Basic concepts in SQL

Data Warehousing Architecture

Types of Transformations

• Active Transformation
• Sorter Transformation
• Filter Transformation
• Router Transformation
• Rank Transformation
• Joiner Transformation
• Union Transformation
• Aggregator Transformation
• SQL Transformation
• Passive Transformation
• Expression Transformation
• Sequence Generator Transformation
• Stored Procedure Transformation
• Connected Transformations
• Unconnected Transformations

Real-time Scenarios

• Finding difference between source tables and target tables
• Finding Duplicate Records
• Finding Junk Values
• Incompatible and duplicate data