ETL Testing Training in Hyderabad - PowerPoint PPT 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
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
Recommended
CrystalGraphics Presentations
