What criteria should be used to determine if an existing data mart should continue to exist? The data mart is not an independent data mart, however, the architecture behind is changing. Therefore, a migration strategy to the new environment must be developed. It also seems like a good opportunity to evaluate the mart's viability.
Douglas Hackney's Answer:You'll face more political/change management challenges than technical ones in this scenario. If the mart doesn't have any users, then it's no problem, just change it. If it has users, then it has a political constituency and existing reports/queries/analysis/spreadsheets/etc. that depend on it. You'll need to do a lot of lobbying and a lot of change management as you build the political will to drive the change and to manage the transition. Prepare for a lot of angry users when they discover that they must rebuild every query and report.
Sid Adelman's Answer: The viability of a data mart would include how well it meets your service level agreements for availability and performance, how well it supports the users' requirements, its ability to expand and add new data, the cleanliness of the data and its ability to integrate with other data marts and your enterprise data mart.
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