Jump to content

ETL Testing Online Training|Support


training21

Recommended Posts

We Provide Online Training |Training| Support  ETL TESTING  with Real Time Experts  :

ETL 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

1504594470ETL%20Testing.jpg

Contact US : 309 - 200 - 3848 / 2019051656 / +91 9030990003

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...