| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: What is the Difference between a ODS and Staging Area
|
| March 03, 2007 07:45:15 |
#1 |
| mithunmca |
Member Since: January 2007 Total Comments: 6 |
RE: What is the Difference between a ODS and Staging A...
|
ODS :-Operational Data Store which contains data .
ods comes after the staging area
eg:-
In our e.g lets consider that we have day level Granularity in the OLTP & Year level Granularity in the Data warehouse.
If the business(manager) asks for week level Granularity then we have to go to the oltp and summarize the day level to the week level which would be pain taking.So wat we do is that we maintain week level Granularity in the ods for the data,for abt 30 to 90 days.
Note : Ods information would contain cleansed data only. ie after staging area
Staging Area :-
It comes after the etl has finished.Staging Area consists of
1.Meta Data .
2.The work area where we apply our complex business rules.
3.Hold the data and do calculations.
In other words we can say that its a temp work area.
|
| |
Back To Question | |
