Typical Roles In DWH Project : Different kinds of roles which are typically found in a DWH project are discussed in this section.

DW/BI/ETL Test Stratergy and Data Centric Approach : In this we talk about the different phases of Data Centric Test Strategy

14

Different Categories Of Projects where DW/BI/ETL Testing is required : This section outlines the different categories of DWH projects in which there is a need for DW/BI/ETL testing to be done.

15

Roles and Responsibilities of an ETL Testing Professional : ETL testing role is one of the critical roles in a Data warehouse project. This section outlines the different roles and responsibilities of an ETL testing professional.

16

Database Testing : In this section we talk about the different types of Database Testing and how to opt for those based on the project.

17

Basics of ETL Testing

18

Database Testing Vs ETL Testing : In this section we talk about the differences between Database Testing and ETL Testing. Also, we talk about the best options to use based on the project situation.

19

Defect Management : This section outlines the different aspects of the Bug Report

20

Possible Reasons for Defects & Bugs : This section outlines different reasons and situations which cause the defects to arise and how to over come them

21

Issues/Defect Management Process : The following Defect Management process should be followed in order to reduce issue turn around time.

22

Issue Severity Table : The following section outlines the criteria for determining the severity of a given issue.

23

Quality Center Defect Category Descriptions : This section provides descriptions of the defect status category labels that can be assigned to issues in QC.

24

Categories of ETL Testing : In this section we talk about the most common most common types of tests that need to be done for ETL Testing.

25

Different Tools/Technologies used in DWH/BI/ETL Testing : In this section we talk about the different Tools/Technologies used in DWH/BI/ETL Testing.

26

Informatica Power Center (ETL Tool) Types of Databases used in ETL Testing

27

Installation and Configuration of Informatica Power Center : In this section we will talk about different steps to download the software and install it.

28

Informatica - Pre-Requisites to start the Hands on : In this section we will start with setting up all the basic stuff for you to get started with the hands on exercises.

Introduction to Transformations : In this section, we talk about the different transformations available in Informatica

31

Transformation's functions in brief : In this section, we talk about the available transformations in brief.

32

Data Types in Informatica : Conversion of the native datatypes to the compatible transformation datatypes

33

Different Types of Ports in Informatica : In this section, we talk about the different types of ports in Informatica

34

Functions in Informatica : In this section we talk about different commonly used functions

35

Workflow Manager : In this section, we learn the sub tools available in Workflow Manger and the importance of them.

36

Informatica PowerCenter MonitorInformatica Power Center Monitor

37

Other important objects and activities in Informatica : In this lecture, we talk about the other important objects and the activities in Informatica

38

Practical Scenario : Flat File Source to Flat File and Relational Targets : In this section we see the mapping creation and workflow execution of the Flat File Source to Flat File and Relational Targets

01 Welcome! Thank you for learning the ETL Testing Course with me

02 What is Data ETL Testing and the Challenges in ETL testing
03 What will be the future of ETL tools testing as big data is getting popular

04 Master Data Warehouse Concepts Step by Step from Scratch
05 Is Data Warehouse still relevant in the age of Big Data
06 What is Data
07 Why Data Warehouse is implemented
08 What is a Data Warehouse

009 What is a Data Mart
0010 Fundamental difference between Data Warehouse and Data Mart
011 Mistakes and Misconceptions of a Data Mart

00226 Requirements for Flat File Source to Flat File and Relational Target
00227 Required Target Attributes based on the requirement
00228 Target Table creation based on the requirement
00229 Source Flat File Creation with the test data
00230 Source File directory for the source to be placed
00231 Let_s create the mapping with the requirements at hand
00232 Workflow Creation for the mapping created with the requirements
00233 Different aspects-areas which needs to be verified during a workflow run
00234 What is S2T document and what should this document contain
00235 Source to Target Mapping - Sample 1
00236 Source to Target Mapping - Sample 2
00237 Source to Target Mapping - For the requirements we are using
00238 Technical Test Cases
00239 Verifying the workflow run and the source to target records
00240 Test Cases for Business and Data Validations
00241 Bug fixes for the issues identified
00242 Restarting the Workflow for further testing
00243 Duplicate Records Check and Record Count Verification
00244Data Validation Checks - Using SQL queries Create - Delete- Drop- Select- Minus
00245 Test Case for verifying the Unique Sequence numbers
00246 Fix and Retest of the Active Flag scenario