This course is designed to learn ETL Testing in detail.
INR 14,000 INR 12,000
You can make this payment online after first 2 classes.
Hours (10 Classes of 2 Hours Each)
- Weekend (Saturday & Sunday)
- Weekdays (In Early Morning & Nights)
- What is Data?
- What is a Data Warehouse?
- Why is Data Warehouse implemented?
- What is Data Mart?
- Data Warehouse vs. Data Mart
- Advantages & Disadvantages of a Data Mart?
- Characteristics of a Data Mart?
Data Warehouse Architectures
- Enterprise Architecture
- Centralized Architecture
- Multi Tier Architecture
- Components of a Data Warehouse Architecture
- Staging Area
- What is Data Modeling?
- Why should a Tester know Data Modeling?
- Data Modeling Techniques?
- ER Data Model?
- Dimensional Model?
- ER Model vs. Dimensional Model
Build a Dimensional Model
- Phases for a Dimentional Data Model
- Business Requirements
- CDM – Conceptual Data Model
- LDM – Logical Data Model
- Physical Data Model
Objects in a Dimensional Model
- Dimension Table
- Fact Table
- Additive Facts
- Semi Additive Facts
- Non-Additive Facts
- Fact Less Facts
- Star Schema
- Snow Flake Schema
- Galaxy Schema or Fact Constellation Schema
- Snow Flake vs. Star Schema
- Conformed Dimensions
- Junk Dimensions
- Degenerate Dimensions
- Role Playing Dimensions
- Slowly Changing Dimensions
Data Integration and ETL
- What is Data Integration?
- What is ETL?
- Data Acquisition
- Data Transformation
ETL vs. ELT
- ETL vs. ELT
- Structural Database Testing
- Functional Database Testing
- Non Functional Database Testing
- Database Testing vs ETL Testing
Categories in ETL Testing
- Metadata Testing
- Data Completeness Testing
- Data Quality Testing – Data Duplicates
- Data Quality Testing – Business Validation and Rules
- Data Transformation – White Box Testing
- Data Transformation – Black Box Testing
- ETL Regression Testing
- Reference Data Testing
- Incremental ETL Testing
- ETL Integration Testing
- ETL Performance Testing
Installation and Configuration of Informatica Power Center
- Download Software
- Power Center Server Installation
- Power Center Client Installation
- Repository Configuration and Folder Creation
- Basic File Directory Structures
- Different Categories of Transformations
- Active Transformations
- Passive Transformations
- Connected vs Unconnected Transformation
- Multi Group Transformations
- Restricted Process Transformations
- Data Flow Rules
- Introduction to Transformations and its Functions
- Aggregator Transformation
- Expression Transformation
- Filter Transformation
- Joiner Transformation
- Lookup Transformation
- Normalizer Transformation
- Rank Transformation
- Router Transformation
- Sequene Generator Transformation
- Stored Procedure Transformation
- Sorter Transformation
- Source Qualifier Transformation
- Update Strategy Transformation
- XML Source Qualifier Transformation
- XML Parser Transformation
- XML Generator Transformation
- Union Transformation
- HTTP Transformation
- Transaction Control Transformation
- Identity Resolution Transformation
- Custom Transformation
- Data Masking Transformation
- Data Types in Informatica
- Data Type Conversion
- Ports in Informatica
- Functions in Informatica
- Workflow Manager
- Workflow Monitor
- Source File Directory for the source to be placed
- Create Mapping with Requirements
- Workflow Creation for the mapping created with the requirements
- Source to Target Mapping
- Test Cases for Business and Data Validations
- Duplicate Records Check and Record Count Validation
- Data Validations Checks
Interview Questions & Answers
If you are interested or have any query, please text or WhatsApp at +91-9910-399-344 or email me at firstname.lastname@example.org