Do you have any suggestions for automated end-to- end testing for a data warehouse implementation? If so, what level of ongoing testing or validation should be performed once the data warehouse is implemented?
Sid Adelman’s Answer: The automated part is usually implemented as part of the sustenance of the data warehouse, post implementation. The automation of testing includes tie-outs that validate the ETL process. These tie-outs look for the number of records going into the ETL process and validates to the number of records loaded. The tie-outs also validate numbers and dollar amounts.
Clay Rehm’s Answer: I personally have not seen or used tools for complete end-to- end automated testing. That is not to say they don’t exist or don’t work. However, in my experience, some testing always requires the review of a human.
There is testing you should be performing on an ongoing basis. You can easily automate many functions or purchase tools that do the following:
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access