Analyzing sources, checking functions
Data warehouses integrate information from differently structured (often distributed) data stocks. The correct extraction, transformation and loading of the data (ETL) is therefore of central importance. Testing thus includes checking the program functions and processes as well as analyzing the data coming from different sources with regard to correct transformation. Prototyping, module and interface testing as well as End-2-End testing are particularly suitable test approaches for the challenges listed above.

In prototyping, the test creates its own image of the development implementation.
Module and interface testing are more of a classic testing approach. Functional test interfaces (ETL) are tested selectively and are highly specialized. Compared to prototyping, the lead times are short and the error detection rate is high. In contrast, test coverage is low, especially from a technical point of view.
In the End-2-End, the complete DWH system is accepted as a black box and evaluated on its output. This time-consuming procedure requires a high level of technical know-how and is of great importance in acceptance procedures.
Services
The OBJENTIS offer includes:
- Assessments: Based on the analysis of existing or planned test processes, OBJENTIS works with the client to develop a concept for DWH testing.
- DWH testing support: Whether End-2-End testing, interface testing or prototyping, DWH testing in particular requires the experience, technical knowledge and professional understanding that our consultants bring with them. Through our DWH Test Management Support we assist our customers with DWH test-experienced coordinators.
- Support for the introduction of tools: DWH testing is tool intensive. OBJENTIS is familiar with numerous tools, and will support you in their selection and implementation.
Benefits
- Economic testing is the guiding principle when it comes to Data Warehouse Testing in particular. Data Warehouse Testing can be optimized by choosing a suitable test approach and the flexible use of tools and methods depending on current project requirements. Our employees provide support and expert know-how in areas like testing coordination/management and optimizing test automation for the benefit of customers.