In my last column, I took a look at some of the rationale behind the data mart consolidation (DMC) movement. This month, I suggest some keys to success for anyone considering such an effort based on interviews of eight global data warehouse programs that have successfully accomplished DMC. The following are key findings from the interviews:

DMC can be used to implement a scalable, integrated, multi- application data warehouse that absorbs all analytical-type activity in an organization, or it can be used to "simply" get an antiquated system out of the environment by moving its function to a system still under support from its vendor. Regardless of the ambition, many DMC efforts eventually lead to the first goal. The act of initiating the consolidation idea within an organization seems to spawn more and more consolidation.

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