ETL TESTING

ETL Testing

This course is designed to learn ETL Testing in detail.

PRICE

INR 14,000 INR 12,000

You can make this payment online after first 2 classes.

DURATION:-

Hours (10 Classes of 2 Hours Each)

CLASS TIMING:-

  • Weekend (Saturday & Sunday)
  • Weekdays (In Early Morning & Nights)

SYLLABUS

Introduction

  • What is Data?
  • What is a Data Warehouse?
  • Why is Data Warehouse implemented?

Data Mart

  • 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

Dimensional Modeling

  • 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
  • Database

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
  • ELT
  • ETL vs. ELT

Database Testing

  • 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

  • Pre-Requisites
  • Download Software
  • Power Center Server Installation
  • Power Center Client Installation
  • Repository Configuration and Folder Creation
  • Basic File Directory Structures

Transformations

  • Different Categories of Transformations
  • Active Transformations
  • Passive Transformations
  • Connected vs Unconnected Transformation
  • Multi Group Transformations
  • Restricted Process Transformations
  • Data Flow Rules

Transformation’s functions

  • 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

Informatica’s Objects

  • Data Types in Informatica
  • Data Type Conversion
  • Ports in Informatica
  • Functions in Informatica
  • Workflow Manager
  • Workflow Monitor

Practical Scenarios

  • 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 deepakraja@devtestops.in

WhatsApp Me