FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:
FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   

What are the implications to staging area and ETL process of incorporating an ODS?

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?


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.

For more information on related topics, visit the following channels:



Industry Vendors