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?
Chuck Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored four books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@usa.net.
Be the first to comment on this post using the section below.