Testing Data Warehouse

BANGALORE, INDIA: In today's fast paced business environment, it is almost always an unstated fact that the success of any Data Warehouse solution lies in its ability to not only analyze vast quantities of data over time but also to provide stakeholders and end-users meaningful options that are based on real-time data.

This requirement mandates an extremely efficient system that can extract, transform, cleanse and load data from the source systems on a 24*7 basis without impacting the performance, scalability or causing system downtime.

One of the key elements contributing to the success of a Data Warehouse solution is the ability of the test team to plan, design and execute a set of effective tests that will help identify multiple issues related to data inconsistency, data quality, data security, failures in the extract, transform and load (ETL) process, performance related issues, accuracy of business flows and fitness for use from an end user perspective.

The primary focus of testing should be on the ETL process. This includes, validating the loading of all required rows, correct execution of all transformations and successful completion of the cleansing operation.

The team also needs to thoroughly test SQL queries, stored procedures or queries that produce aggregate or summary tables. Keeping in tune with emerging trends, it is also important for test team to design and execute a set of tests that are customer experience -centric.

Click here to read full article...!