How to Thoroughly Test a Data Warehouse

[article]
Summary:

The purpose of this paper is to describe general data warehouse structure and background, as well as specific situations encountered during the testing effort for our project.

The purpose of this paper is to describe general data warehouse structure and background, as well as specific situations encountered during the testing effort for our project.

Our project was to test a data warehouse and data mart for a large research department of a pharmaceutical manufacturing company. This was a pilot project and our efforts, if successful, would pave the way for future data warehouse projects within the company. Our role on the project team was to provide quality through validation of the business rules.

We met this challenge by determining if the extract/transform/load (ETL) process was functioning in the approved manner. We created basic principles that were used as a starting block for our process.

About the author

Suellen Arbuckle's picture Suellen Arbuckle

Suellen Arbuckle is a Test Lead with Eli Lilly & Company, in Indianapolis, IN. During her 17-year IT career she was a technical writer for Gould Computer Systems and Motorola in Illinois, and Pythia Corporation and Whittman-Hart of Indianapolis. While a consultant for Whittman-Hart, she worked three years as a technical writer on a variety of projects that included legislative software for the Illinois state legislature, logistics management for Mitsubishi, and several smaller projects.

StickyMinds is one of the growing communities of the TechWell network.

Featuring fresh, insightful stories, TechWell.com is the place to go for what is happening in software development and delivery.  Join the conversation now!

Upcoming Events

Apr 29
Apr 29
May 04
Jun 01