Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help with QA Test Plan for DW

Help with QA Test Plan for DW

Help with QA Test Plan for DW


I'm in the process of writing a QA plan (delta load) for our DW.  I've already written test plans for the main functions.  However, my manager is asking me to look for other things we should test in the DW.  Any suggestions would be greatly appreciated.  Thanks.

RE: Help with QA Test Plan for DW

Something that your users are bound to do is to compare the results of current management reports with the figures that they get out of the data warehouse.

This can often be very frustrating as many of the existing management reports will have quirks that effect their values. Often this is why a DW has been created in the first place (to get accurate reporting). But users will consider their old report as 'correct' and any discrepencies in the figures from the DW as 'wrong'.

You might be able to head them off by doing some comparisons in your testing. More importantly, by getting a power user involved with the testing to aid acceptance of the new system.

My home ----> http://www.geocities.com/jnicho02/
My company -> http://www.firstlightassociates.co.uk/

RE: Help with QA Test Plan for DW

Hi Rayrod

I am just strating as a QA manager in data warehousing shop. Never done DW before.

Any chance I can get some tesp plan templates?

Are you using any tools, or just like us - SQL queries?


RE: Help with QA Test Plan for DW

Have a look at a tool called Discovery from AVELLINO. It looks at your data and identifies quality issues.


Hope this helps,



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close