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?

You obviously need to test your extract, transform and load (ETL) process as you develop it, and you need to, not really test, but verify the results each time the ETL process runs and the ETL tools have tie-outs that will verify that the database loaded correctly. In addition, the folks who run the queries and reports should always validate their results. Make sure you have a validation module in your user training course.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access