ETL Warehouse Testing Tool, and Regression testing
Hi All, I promise not to start a which tool should I buy post, but I am looking for a tool to solve all our problems... so it may end up that way, but I am commited to providing details of what I am looking for...
The data warehouse testing group I am working with currently tests an active and enterprise data warehouse. Each warehouse consists of multiple marts, and is large (many clients) not that it matters... The warehouses are built on the DB2, and the Teradata platforms. The development organization is done on the Data Stage platform (IBM)
The current testing practice completely manual consisting of 4 discreate testing phases: 1, data inspection (the inspection of source files); 2, system testing (testing the ETL); 3, user acceptance testing (testing with the client); 4, post implementation testing (testing the load of the project into production. By completely manual, I mean that a tester typically runs SQL directly against the warehouse from test cases built from the functional requirements. The testers do not currently leverage any part of the Data Stage tools.
The current testing has a very high quality, but it is expensive.
I am looking for the following:
1. A tool make the testing more efficient
2. An approach to regression testing a data warehouse (are there tools different from functional testing tools for this?)
My group is currently documenting our testing tool requirements, but any help to get us kick started would be greatly appreciated.
Re: ETL Warehouse Testing Tool, and Regression testing
Check for DVO data validator or DB Unit to automate moderately.