ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database.
What Will I Learn?
Understand the concepts of Business Intelligence Data warehousing
Get to know what is ETL Testing, QA Lifecycle and RDBMS Concepts
Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Business Rules Testing, Negative Scenarios Testing, Dependency Testing, Error Handling Testing
Perform data Checks using SQL and understand the scope of BI Testing