| |
GeekInterview.com > Interview Questions > Data Warehousing
| Print | |
Question: Staging and Operational Data Store
Answer: What are Staging and Operational Data Stores and what is their difference?
Why does one need staging and why does one need ODS?
What will happen if they are not there?
Who and how is it decided that a staging or ODS is needed?
Which comes first staging or ODS? |
| May 05, 2009 01:38:45 |
#1 |
| ITdevil |
Member Since: May 2009 Total Comments: 1 |
RE: Staging and Operational Data Store
|
| Staging area is also called 'Operational Data Store'™ (ODS). It is a data holding place where the data which is extracted from all the data sources are stored. From the Staging area, data is loaded to the data warehouse. Data cleansing takes place in this stage. |
| |
Back To Question | |
