ETL TESTING ONLINE TRAINING FROM HYDERABAD IN HYDERABAD

Type Tutoring ETL Testing Online Training from Hyderabad Course Content: DATA WAREHOUSING 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 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 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 Integration testing Module testing System testing UAT PRACTICE SESSIONS ON ETL TESTING