Question: What are the differences between ODS, EDW and a central repository and their specific uses? We have delivered several subject-specific data marts to the business. The task at hand is to reverse engineer the denormalized star schema data mart data into a more normalized structure.The reason behind this project is to have the capability to provide other data marts that will help to answer business questions which cannot be answered with the existing marts.I struggle with whether we need to build an ODS, EDW or a central repository/CIF.


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