ETL TESTING ONLINE TRAINING
0
|
ETL Testing COURSE
CONTENT
|
|
|
DataWarehousing concepts:
|
|
|
|
|
|
DBMS and RDBMS
|
|
|
What is Data Warehousing and
necessity of it?
|
|
|
Data warehousing architecture
|
|
|
OLAP,ROLAP, MOLAP
|
|
|
Data mining
|
|
|
Meta data
|
|
|
Tables, views
|
|
|
Constraints
|
|
|
Fact and Dimensional Tables
|
|
|
Partitioning of tables
|
|
|
Concepts of Referential Integrity
|
|
|
Concepts of Modeling
|
|
|
Database Schema
|
|
|
Concepts of normalization
|
|
|
Concepts of Slowly Changing
Dimensions
|
|
|
Concepts of Data Mart
|
|
|
Full and Incremental extraction
Process
|
|
|
Change Data capture
|
|
|
|
|
|
SQL Concepts:
|
|
|
|
|
|
DDL, DML commands
|
|
|
All the basic functions (Character
Functions,
|
|
|
Conversion Functions, Advanced
functions,
|
|
|
Mathematical Functions and Date
Functions)
|
|
|
Joins
|
|
|
Practice SQLs for some sample test
scenarios
|
|
|
|
|
|
ETL testing:
|
|
|
|
|
|
What is ETL and importance of ETL
testing??
|
|
|
Creating, running and analyzing
sessions/workflows in Informatica
|
|
|
Preparation of Test strategy, Test
plan and estimations
|
|
|
Testing scenarios, creation of test
cases and scripts
|
|
|
Test case execution & defect
tracking & reporting
|
|
|
|
|
|
Report Testing:
|
|
|
|
|
|
Validation of the report data with
DB and UI testing
|
|
|
Preparation of Test data
|
|
|
|
|
|
Levels of testing
|
|
|
|
|
|
Unit testing
|
|
|
Integration testing
|
|
|
Module testing
|
|
|
System testing
|
|
|
Uat
|
|
|
|
|
|
Practice sessions on ETL Testing
|
|
|
|
|
