We are looking at the future architecture of our data warehouse. We currently have several account-level fact tables developed for different applications. These duplicate a lot of the data, and I am wondering whether this is the correct approach. Would it not be better to consolidate these into one fact table for the enterprise and then have different aggregates and access methods for each application? Should the detailed level fact tables be part of the enterprise data warehouse, or should they be data marts for specific purposes?

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