ETL Testing
Register for Free Demo
Database Testing Concepts:
- What is Database Testing
- Database Testing Architecture
- Stages involved in Database Testing
- Fundamentals of Database Testing
- Components of the database
SQL
- Introduction to SQL
- DDL Statements
- DML Statements
- DCL Statements
- SQL Operators, Triggers, Cursors, Sequences & Indexes
- Sub Queries and Joins
- Union, Intersect and Minus
- Views, Stored Procedures & Functions
- 100 SQL Queries Hands on
Data Warehousing Concepts:
- What is Data and the Types of Data?
- Introduction of Data Warehouse
- Data Warehouse Architecture
- Data Extraction
- Data Transformation and Types of Transformations
- Data Loading
- Characteristics of Data Warehouse
- What is OLTP
- What is OLAP
- Difference between OLTP & OLAP
- What is Meta Data?
- Differences between DB Testing & DWH Testing
- DWH Challenges
Data Marts:
- What is Data Mart and How it is different from a data warehouse
- Types of Data Marts
- Reasons for building a Data Mart
- Advantages & Disadvantages of a Data Mart
- Data warehouse vs. Data mart
Dimensional Modeling:
- What is Dimensional Modeling and why it is important?
- Dimensional Model architecture
- Attribute
- Hierarchy
- What is Fact table and its purpose?
- What is Dimension table and its purpose?
- Granularity or Grain of Fact Table
- Primary key
- Surrogate Key
- Look Up Table
- ER Modeling Vs. Dimensional Modeling
- Normalization
SCD (Slowly Changing Dimension:
- What is SCD (Slowly Changing Dimension?
- SCD Type 1
- Advantages & Disadvantages of SCD1
- SCD Type 2
- Advantages & Disadvantages of SCD2
- SCD Type 3
- Advantages & Disadvantages of SCD3
Schema Models:
- Types of Schema Models
- Star Schema Model
- Advantages & Disadvantages of Star Schema Model
- Snow Flake Schema Model
- Advantages & Disadvantages of Snow Flake Schema Model
- Constellation or Mixed or Galaxy Schema model.
DW Design Methodologies:
- Inmon’s Design Methodology
- Advantages & Disadvantages
- Kimball’s Design Methodology
- Advantages & Disadvantages
Data Modeling:
- What is Data Modeling?
- Types of Data Models
- Conceptual Data Model
- Logical data Model
- Physical Data Model
- Types of Facts
Life Cycle of the Data Warehouse Project:
- Life Cycle of Data Warehouse Project in the real world
- DWH/ETL Process
Data Warehouse Testing Phases:
- Data Warehouse Testing Phases and phase wise Testing Activities
ETL Testing Concepts:
- What is ETL Testing?
- Role of ETL in a Data Warehouse
- Popular ETL tools
- ETL Testing Goals
- Full Load & Delta Load
Types of testing techniques in ETL:
- Count Checks
- Minus Query
- Look up Query
- Default Checks
- Null Checks
- Audit Table checks
ETL Tester Roles & Responsibilities:
- White box testing
- Black box testing
- ETL Test Strategy Document Preparation
- ETL Test Plan Document Preparation
- Test data Preparation
- How to design the Test cases in ETL Testing.
- How to report the Bugs in ETL Testing?
ETL Tool: Informatica
- Introduction to Informatica
- Informatica Product Line
- Architecture of Informatica
- Informatica PowerCenter Client Tools
- What is Transformation and different types of Tranformations
- Aggregator Transformation
- Custom Transformation
- Expression Transformation
- External Procedure Transformation
- Filter Transformation
- HTTP Transformation
- Input Transformation
- Java Transformation
- Joiner Transformation
- Lookup Transformation
- Output Transformation
- Rank Transformation
- Reusable Transformation
- Router Transformation
- Sequence Generator Transformation
- Sorter Transformation
- Source Qualifier Transformation
- SQL Transformation
- Stored Procedure Transformation
- Union Transformation
- Update Strategy Transformation
- XML Generator Transformation
- XML Parser Transformation
- XML Source Qualifier Transformation
- External Transformation
ADD on’s :
- Real-time Scenario’s using Dim & Fact Tables( ETL Testing using Informatica tool)
- Introduction to OBIEE BI Tool
- UNIX Commands
- Resume Preparation
- Real time Interview Questions