etl1

ETL Testing Training, Data warehouse Testing

  • What is ETL & Data Warehousing?
  • Extraction
  • Transformation
  • Loading
  • Introduction to Data ware house, purpose of DWH with examples
  • DWH Architecture
  • OLTP System vs OLAP System
  • What is a fact table?
  • What is a dimension table?
  • Fact vs. Dimension
  • What is star schema?
  • What is snow flake schema?
  • DWH Tools (different types of dwh tools)
  • Types of data bases used in ETL testing
  • Explaining about data mapping document
  • Testing tools used for ETL testing
  • Process flow in ETL Testing
  • Writing test cases for mapping documents
  • UNIX Commands for ETL Testing
  • SQL Queries and SQL Joins for ETL Testing
  • Real Time Example and project references