What are the disadvantages of having a data warehouse in place? Is the disadvantage connected to the data in the source system with regard to the cleanliness of data or any other issues involved therein?
Chuck Kelley’s Answer: I am assuming you are asking about using the "virtual" data warehouse approach. This approach says you do not need a separate data structure, just some middleware that understands the data. The issues I think are:
These are just some of the issues concerning your question. While the concept is interesting, I do not believe the technology has caught up with concept.
Clay Rehm’s Answer: The only disadvantage of a data warehouse is one that is poorly designed! Indeed, a data warehouse will certainly introduce data quality issues as well as many other processes, data and resource changes however, all for the better. It is important to understand that the maintenance of a data warehouse can be a time-consuming and difficult task. A company must make the commitment to supply a dedicated support team, appropriate hardware and software, and business sponsorship to make it effective. Even though building and maintaining a successful data warehouse is a difficult job, the benefits far outweigh the expense.
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