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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access