We are migrating from one data warehouse to a new one. Which questions need to be asked to perform a technical analysis of the old environment in order to create a profile of the old data warehouse?
Sid Adelman's Answer: Most of the questions you need to ask go far beyond the technical. You need to get an understanding of the existing environment in each of the following areas:
Clay Rehm's Answer: My first question is why are you moving from one data warehouse to another? Is this a business division request or a technical request? I assume you are moving for one or many good business reasons. If the reason is a technical reason, is it to reduce cost, increase performance or improve ease of use?
Having said that, increasing performance can be accomplished many ways. This would include modifying the database design (data model), adding/modifying indexes, partitioning, changing the network bandwidth, moving the database from one server to another, and so on. The solution can be one of these items or a combination of them.
I would suggest reading the book Data Warehouse Project Management by Adelman/Moss, and Impossible Data Warehouse Situations with Solutions from the Experts (multiple authors). These books cover the requirements gathering techniques you will need to accomplish your goal.
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