ETL Testing

Course outline

ETL Concepts

• Data warehousing and Business intelligence
• The Dimensional Model
• Oracle OLAP
• Data warehouses and data marts
• Data warehouse development approaches and terminology
• Business, Logical, Dimensional and Physical Modeling
• The ETL Process: Extracting the data
• Extraction Methods
• Change Data Capture
• Possible ETL failures
• Maintaining ETL quality
• The ETL Process: Transforming the data
• Transformation and available staging models
• Identifying and eliminating data anomalies
• Importance of the quality data
• Transformation: Problems and Solutions
• MERGE and multiple INSERT SQL statement in Transformation
• The ETL Process: Loading the data
• Transportation in a Data warehouse
• Data refresh models
• Data Granularity
• Post processing of the Loaded data
• Steps for verifying the data integrity
• Standard quality assurance checks.