Etl Testing

An ETL tool extracts the data from all these heterogeneous data sources, transforms the data (like applying calculations, joining fields, keys, removing incorrect data fields, etc.), and loads it into a Data Warehouse. This is an introductory tutorial that explains all the fundamentals of ETL testing


 Module 1 - Data Warehousing Concepts
  • Introduction to OLTP, and OLAP Systems
  • Introduction to Data Warehousing
  • Data Modelling
  • Normalization/De-normalization
  • Schema
  • Star Schema
  • Snowflake Schema
  • Types of Dimension Tables (Confirmed, Junk, Degenerated)
  • Types of Fact Tables (Additive, Semi-Additive, Non-Additive)
  • Dimensional Modelling
  • Fact less Fact table
  • Change Data Capture (CDC)
  • Slowly Changing Dimensions (SCD Type1, SCD Type2, SCD3 Type3)
  • MD5
  • Data Loading Techniques (Initial/Full, Incremental/Delta)
 Module 2 - Oracle Concepts / T-SQL
  • Data Definition Language (DDL)
  • CREATE, ALTER, DROP, TRUNCATE
  • Data Manipulation Language (DML)
  • INSERT, UPDATE, DELETE
  • Data Retrieval Language (DRL)
  • SELECT
  • Capabilities of the SELECT statement
  • SET Operators
  • UNION, UNION ALL, MINUS, INTERSECT
  • Creation of Backup Tables
  • Numerical Functions
  • String / Character Functions
  • Date / Time Functions
  • Data Conversion Functions
  • Data Analytical Functions
  • Pseudo Functions
  • Type of Joins
  • Creating Views and Indexes
  • Data Keys, Constraints
  • Practicing on TOAD and SQL Loader
  • Regular Expressions
  • Materialized views
  • Stored Procedures, Functions
 Module 3 – Manual Testing Concepts
 Module 4 – UNIX Basic Commands
 Module 5 – Agile Methodology (Scrum Framework)
 Module 6 – HP QC/ALM
 Module 7 – ETL Testing
  • What is ETL Testing ?
    ETL Testing Strategies
    Informatica Power Center Components
    • Designer, Repository Manager, Workflow Manager, Workflow Monitor Source Analyzer, Target Designer, Mapping, Session, Workflow
 ETL Testing with Informatica
  • SAMPLE Loading from source to target
  • SORTER Transformation
  • FILTER Transformation
  • ROUTER Transformation
  • EXPRESSION Transformation
  • Look up Transformation
  • JOINER Transformation
  • AGGREAGATOR Transformation
  • SEQUENCE GENERATOR Transformation
  • Update Strategy
  • Flat File - Source/Target
  • Excel - Source/Target
  • SCD type 1
  • SCD type 2
  • SCD type 3
  • Types of load (Full/Initial, Incremental/Delta)
 Module 8 – ETL Testing with SSIS
 Module 9 – Difference between Oracle SQL and Microsoft SQL (T-SQL) Functions
 Module 9 – Difference between Oracle SQL and Microsoft SQL (T-SQL) Functions
 Module 11 – Interview Questions & Answers


Click here to Download the Etl testing syllabus.

ADDRESS

  • Address: #12, 3rd Floor
    Dental College Main Road,
    Munekolalu, Marathahalli,
    Bangalore - 560037
    Karnataka.
  • Email: info@krninformatix.com
  • Website: www.krninformatix.com

GALLERY

image 1 image 2 image 2 image 2
image 1 image 2 image 2 image 2