Best Practices for ETL Testing
- Make sure data is transformed correctly
- Without any data loss and truncation projected data should be loaded into the data warehouse
- Ensure that ETL application appropriately rejects and replaces with default values and reports invalid data
- Need to ensure that the data loaded in data warehouse within prescribed and expected time frames to confirm scalability and performance
- All methods should have appropriate unit tests regardless of visibility
- To measure their effectiveness all unit tests should use appropriate coverage techniques
- Strive for one assertion per test case
- Create unit tests that target exceptions
