Is it necessary to create a data warehouse separate from the operational data store (ODS)? Can one have an ODS created around a dimensional design and just add additional summary tables or dimensions as needed instead of creating a data warehouse?


Chuck Kelley’s Answer: I believe the operational data store is an operational system, so they will be different than the data warehouse. They will be a great feeder of the data warehouse.

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