ETL Testing in Less Time, With Greater Coverage, to Deliver Trusted Data
Much ETL testing today is done by SQL scripting or “eyeballing” of data on spreadsheets. These approaches to ETL testing are very time-consuming, error-prone, and seldom provide complete test coverage. The Informatica Data Validation Option provides an ETL testing tool that can accelerate and automate ETL testing to a point where it becomes easy to provide 100% test coverage, even with zero programming skills.
ETL Testing Use Cases
- Application Upgrades (same-to-same ETL testing). This type of ETL testing validates that the data coming from an older application or repository is exactly the same as the data in the new application or repository. Most of this type of ETL testing can be automated.
- Source to Target Testing (data is transformed). This type of ETL testing validates that the data values after a transformation are the expected data values. The Informatica Data Validation Option has a large set of pre-built operators to build this type of ETL testing with no programming skills required.
- Production Validation Testing (testing data before moving into production). Sometimes called “table balancing” or “production reconciliation,” this type of ETL testing is done on data as it is being moved into production systems. The ETL testing is often run in a “lights out” mode with the execution of the Load conditional on passing all of the ETL testing cases. After production ETL testing you can be sure that the data loaded into your production systems is correct.
Benefits of ETL Testing with Data Validation Option
- IT Developer Productivity. 50% to 90% less time and resources required to do ETL testing while providing complete test coverage.
- Data Integrity. Full ETL testing coverage means lower business risk and greater confidence in the data.
- Lower Business Risk. With full ETL testing, including in production use cases, you can be sure that the data backing important business decisions is accurate. The Informatica Data Validation Option also provides a complete audit trail for ETL testing, speeding up and improving the quality of the audit process for regulatory compliance.