What is the best way to test a data warehouse?

OCT 2, 2006 1:00am ET

Q: Please send me info about how to test a data warehouse - beginning with the act of defining requirements up to the point of design. Do I need testing software or can it be achieved by means of test cases? What kinds of test cases would you recommend?

Sid Adelman's Answer:

Get access to this article and thousands more...

All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:

  • Full access to information-management.com including all searchable archived content
  • Exclusive E-Newsletters delivering the latest headlines to your inbox
  • Access to White Papers, Web Seminars, and Blog Discussions
  • Discounts to upcoming conferences & events
  • Uninterrupted access to all sponsored content, and MORE!

Already Registered?

Filed under:

Comments (1)
I agree with Adrienne. Data warehouse testing is very complex and many different issues can arise. Here are some that we found http://www.querysurge.com/Site/web/resources/white-papers/Common-Data-Defects.pdf

I also created a YouTube video called "What is a Data Warehouse and How Do I Test It?". I think it provides a pretty good look at the process. http://www.youtube.com/watch?v=qe39vPFabuA


Bill Hayduk RTTS

Posted by Bill H | Wednesday, October 17 2012 at 6:07PM ET
Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.