Identify your business requirements. … Assess your data sources. … Create test cases. … Begin the ETL process with the extraction. … Perform the necessary data transformation. … Load the data into the target destination. … Document your findings.
How do I start learning ETL Testing?
- Identify business requirements — Design the data model, define business flow, and assess reporting needs based on client expectations. …
- Validate data sources — Perform a data count check and verify that the table and column data type meets specifications of the data model.
Is coding required for ETL Testing?
ETL tools can be Future Proof Writing code for a particular data warehouse needs to be in the language specific to that system. Most ETL tools, however, don’t do this! They are generalistic to work with many data warehouses. This means that each set of code written is specific to each individual data warehouse.
