| |
|
|
|
|
| Online Training From India, B1, 3rd Floor, Eureka Court, Beside Image Hospitals, Ameerpet, Hyderabad. |
|
|
|
|
|
| ETL Testing Online Training : |
Course Duration - 40hrs |
DataWarehousing concepts:
- DBMS and RDBMS
- What is DataWareHousing 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 Modelling
- 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 analysing sessions/workflows in Informatica
- Preparation of Test strategy, Test plan and estimations
- Testing scenarios, creation of test cases and scripts
- Test case execution and defect tracking and reporting
Report Testing:
- Validation of the report data with DB and UI testing
- Preparation of Test data
Levels of testing
- Unit testing
- Intigration testing
- Module testing
- System testing
- Uat
Practice sessions on ETL Testing |
| |
|
|
|
| |
|
