Data Warehouse Testing

No data warehouse project is ever over without a planned and organized testing phase. Well instituted testing often exposes not only errors in programming but also flaws in the design, especially in the ETL component. Testing will also uncover shortcomings in the initial research to identify business needs, as users suddenly seek a level of granularity that the design didn't expect and hence didn't accommodate.

Proper testing requires a plan and cannot be done independent of the business information gathering process. The key to setting up such a plan needs understanding of the underlying business rules. These are the same rules that the data architects used for the initial design.

e-Biz Technologies Has a Proven Data Warehouse Testing Methodology

The initial planning will take into account requirements, business rules, performance and flexibility. Our data warehouse professionals at e-Biz Technologies understand what it takes to thoroughly test an implementation, ensuring that the project objectives have indeed been met. We understand the key elements that need to be in place for proper testing and validation to occur. These include the availability of a data dictionary, a flexible ETL process, the right personnel and the ability to develop automated scripts.

Testing a data warehouse implementation is not an end in itself, but rather part of a feedback loop where new business requirements might come into light during this phase that would need changes at the ETL level. Flexibility and expandability are the keys to ensuring that all user requirements can be met. Contact our data warehouse specialists at e-Biz Technologies for more information.