Etl testing qa online training in hyderabad
ETL
TESTING
What
is ETL?
ETL (Extract Transformation and
Load)testing is different from Database testing or backend testing both in
terms of complexity and scope and hence requires a different approach as
against conventional testing.The methodology primarily aims at
identifying and mitigating existing data defects and general errors occurring
prior to processing of data for analytics and reporting.
The
ETL Testing Methodology includes following steps:
- Understanding
of data to be reported
- Understanding
and review of data model
- Understanding
and review of source to target mappings (transformations)
- Data
Quality Assessment of Source data
- Packages
testing
- Schema
testing (source and target)
- Verify
Data completeness
- Verification
of transformation rules
- Comparison
of sample data between source and target
- Checking
of referential integrities and relations (primary key foreign key)
- Data
Quality checks on target warehouse
- Performance
tests
Topics
- Introduction to Database
- Simple Select Queries
- Create, Insert, update querie
- Alter queries, delete, drop, truncate
queries
- Working with Arithmetic functions
- Working with Aggregate functions
- working with date functions
- Queries using Where clause, Having clause,
group by and Order by
- Equi Joins, Inner Joins, non-equi joins
- Outer joins- left and right outer joins
Introduction
to Dataware house
- ER Model
- Dimensional Model
- Dimension tables and Fact tables
- Star Schema
- Snow Flake Star Schema
Types of
Dimensions
- Confirmed Dimension table
- Junk Dimension table
- Types of
Fact tables
- Additive Facts
- Semi Additive Facts
- Non-Additive Facts
- Enterprise ware house schema
- Data marts
- Top to bottom approach
- Bottom to top approach
- ODS (Operational Data Source)
- Difference between OLTP and OLAP
- ROLAP, MOLAP,HOLAP
- Data Slicing and Data dicing
ETL
Testing
- ETL Testing-Data preparation
- ETL Testing-types
- Informatica (ETL Tool)-Importance and understanding
- Informatica Workflow Manager
- Informatica Workflow monitor
- ETL Working Examples
- Example1: Flat file to table
- Test cases for Example1
- Example2: table to table
- Test cases for Example2
- Example3: flat file to table with business rules
- Example4: table to table with business rules
- Example5: Multiple files to single target table with business rules
- Example6: Multiple tables to single target table with business
rules
- SCD1 Testing
- SCD2 Testing
- SCD3 Testing
Quality
Center-Introduction
- Requirements tab
- Test Plan tab
- Test Lab tab
- Defect tab
- Importing test cases from excel to Quality
Center
etl testing,etl testing online training,software testing
training,online testing training,etl testing training online,etl testing
training videos
testing training online testing online trainingetl
testing training in bangalore software testing training online online etl
testing training
software testing training in chennai software testing
training institutes etl training online etl testing online training in
hyderabad best etl testing training institutes in hyderabad online
coursesonline training coursesEtl
testing qa online training in hyderabad