Q: What are the implications to staging area and ETL process of incorporating an ODS?
Chuck Kelley's Answer: I think this will depend on your definition of a staging area and an ODS. I think that you always need a staging area (except in the most smallest situations), regardless of what you are building so that you can have a place to stage the data from the source systems. So if you are building an ODS, you will probably need some more data for a data warehouse. Where would you stage that other than in a staging area?
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