Q: When you have multiple disparate applications with redundant dis-integrated data that very loosely applies business rules wouldn't you advocate a business rules enforced enterprise repository (ER) structure first and then a data mart for your source reports and then having the ER serve as a drill-down repository?

I think that there are two ways to accomplish this: 1) To use the ER structure as you define in you question, and 2) build a loosely historical layer of data and then build the data mart for drill down and reports. The reasoning behind number two is that as the business changes, you don't necessarily have to change the really tight ER structure. Either way works - you have to decide what is best for your company.

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