ETL Testing Training in Hyderabad - PowerPoint PPT Presentation

About This Presentation
Title:

ETL Testing Training in Hyderabad

Description:

Why ETL Testing? Accuracy of the data from the ETL process is critical as this underlying information influences business decisions & thereby its efficacy. ETL Testing aims to deliver complete, repeatable & auditable test coverage of the ETL process. – PowerPoint PPT presentation

Number of Views:34
Slides: 6
Provided by: mindqsystems
Category: Other

less

Transcript and Presenter's Notes

Title: ETL Testing Training in Hyderabad


1
Mind Q Systems
  • Leaders in Training

Online Training Weekend Training Class
Room Training
Mind Q Systems 8-3-214/7, 2nd Floor,Srinivasa
Nagar Colony (W)Above HDFC Bank, S.R.Nagar
Hyderabad-500038.  Tel 040-66664291/92 /
040-65544295  Mob 91 9502991277  Email info_at_min
dqsystems.com www.mindqsystems.com
2
ETL Testing Course Content
  • What is Data Warehousing?
  • Difference between OLTP and
  • Data Warehousing
  • Data Acquisition
  • ? Data Extraction
  • ? Data Transformation
  • ? Data Loading

3
ETL Testing Course Content
  • Data Marts
  • ? Dependent DM
  • ? Independent DM Database Design
  • ? Star Schema
  • ? Fact Constellation Schema SCD (Slowly Changing
    Dimensions)
  • ?TYPE1SCD
  • ? TYPE2SCD
  • ? TYPE3SCD Basic concepts in SQL

4
ETL Testing Course Content
  • Overview of ETL Tool Architecture
  • Components in ETL Tool
  • White Box and Block Box testing
  • Functionality in different
  • Transformation rules
  • ? SAMPLE Loading from source target
  • ? SORTER Transformation
  • ? FILTER Transformation
  • ? ROUTER Transformation
  • ? EXPRESSION Transformation
  • ? JOINER Transformation
  • ? UNION Transformation

5
ETL Testing Course Content
  • ? AGGREGATOR Transformation
  • ? RANK Transformation
  • ? STORED PROCEEDURE Transformation
  • ? SEQUENCE GENERATOR Transformation
  • ? Flat File
  • ? SQL Transformation
  • Data warehousing Life Cycle
  • Different Types of testing
  • techniques in ETL
  • ? MINUS Query
  • ? COUNT Query
Write a Comment
User Comments (0)
About PowerShow.com