Data Warehouse Testing and Validation Services
Information stored in a data warehouse is critical to organizations for decision making and predictive analysis. The huge volume of data loaded onto a data warehouse makes exhaustive manual comparison of data impractical. The existing quality tools are either manual or have other limitations, and do not cover all aspects of data warehouse testing. A holistic solution is required to test high-volume applications that are built on Data Warehouse (DW) or Business Intelligence (BI) architecture.
Infosys Clearware, a data warehouse testing solution, is a comprehensive, easy-to-use tool designed to test high-volume, data-centric DW/BI applications. It automates data warehouse test processes, enables extensive reuse of test components, ensures early detection of data defects, and provides complete traceability. Infosys Clearware follows a well-structured model to validate data, enhance quality and accelerate the testing process.
Our tool-based approach to data warehouse testing prevents data anomalies in the production environment. It helps automate test planning as well as test execution activities at every stage in the test lifecycle.
| Ensure adequate test coverage to eliminate defects in the data warehouse process |
- Test automation in the test planning and execution phases
- In-built transformation rule builder increases automation coverage
|
- Exhaustive validation made possible
- Increases productivity and reduces execution effort by 70%
- Saves up to 40% of testing effort
|
| Manage time-to-market despite large volume of manual testing |
- In-built data warehouse test strategies
- Infosys Clearware provides a data quality analyzer to improve quality of data
- Scheduling of test batches for automatic execution of time-consuming queries
|
- High data quality and reliability
- Improves test coverage
- Reduces time-to-market by 25%
|
| Maximize automation across the lifecycle |
- Automatic generation of SQL queries
- Integration with HP Quality Center
- Detailed reporting of anomalies
- Transformation rule builder
|
- Reduce dependency on skilled resources
- Efficient and simplified test management
- Reduces the effort in defect analysis by 80%
|