Data Warehouse Testing - BI
autogen has many advantages that turn through the use of the DWH test in relevant benefits:
Advantages - Benefits: Prio 1
- synthesized test data br>
- reduction of expenses for produktion of test data and test automation
- automated error detection
- high-speed automatic regression testing by small test data sets
- minimizing the maintenance effort for test data
risk control through high test coverage and requirement orientation
revision security as a result of test automation
Advantages - Benefits: Prio 2
- Small testbeds
- Less code reviews
- Fewer or no manual testing
- Early test runs without productive data
- data protection (possibly Prio 1)
- Developer tests are supported
- Agile development is supported
cost savings
time
(data) compliance
autogen in use: you benefit several times
Aufbau einer Tabelle head>
body>
einfache Tabelle
Company uses production data th> | Company uses synthetic data (autogen) | tr>
---|---|
risking de-anonymization | minimize risk of data leaks |
waits for data of the delivery systems | synthesizes test data and runs test any time after code completion | depends on the delivery systems, can not design test cases on method | can synthesize test data for all test cases, which are considered as necessary (special cases) | need of production-like test environment | usage of small test environment (PC) | must calculate long test runs | completes tests within minutes | has high costs for test data archiving and test case maintenance | boosts quality and safety | tr>