Independent data marts have spread like a disease through many of today's best and most advanced corporations. The devastating nature of this disease is that it is not easily detected in its initial stages; however, if it is not treated, the corporation's condition will steadily deteriorate. "Stranded on Islands of Data" in the November 1998 issue of DM Review covered the characteristics of independent data marts, the flaws in their architecture and the reasons why they exist. This follow-up article focuses on the approaches for migration, initial planning, how to identify a migration path and also presents a fictitious case study illustrating how a corporation can migrate from independent data marts to an architected solution of an enterprise data warehouse with multiple dependent data marts.

There are two general approaches for migration: "Big Bang" and "Iterative." Table 1 summarizes the advantages and disadvantages of each approach.

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