ETL ONLINE TRAINIG COURSE

ETL- INTRODUCTION & COURSE CONTENT

Purpose of Datawarehouse

Tools used to Load data into the data warehouse

About Datawarehouse Testing

Need for ETL Testing

ETL Testing phases

  • Business understanding
  • Test plan creation
  • Test environment setup
  • Test script generations
  • Execution
  • Reporting

How is ETL Testing different from normal Testing

How to ensure no data loss

Transformation Rules

Data validation Strategies

  • Data file loads
  • Data validation with in staging tables to check all Mapping rules
  • Data validation with in Target tables to ensure data is present in required format

Staging Area

  • Test approach and procedure in staging area

SOR Area

  • Test approach and procedure in SOR area

Datamarts Area

  • Test approach and procedure in Datamarts area

 

CONTACT US