ETL - What is the Difference between a ODS and Staging Area

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 45 of 65

What is the Difference between a ODS and Staging Area

Total Answers and Comments: 3

Last Update: January 10, 2009 Asked by: nagireddy

Sponsored Links

Best Rated Answer

—

Submitted by: mithunmca

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.

Above answer was rated as good by the following members:
flodhi10

March 28, 2007 07:45:15

mithunmca

Member Since: January 2007 Contribution: 7

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

August 09, 2007 04:33:42

siraj khan

RE: What is the Difference between a ODS and Staging A...

The full form of ODS is Operational Data Store.ODS is a layer between the source and target databases..ODS is used to store the recent data.

Staging layer is also a layer between the source and target databases..Staging layer is used for cleansing purpose and store the data periodically.

Is this answer useful? Yes | No

January 09, 2009 21:31:37

Vamshidhar

Member Since: February 2008 Contribution: 4

What is the Difference between a ODS and Staging Area

ODS (Operational Data Source) is the first point in the Datawarehouse. Its store the real time data of daily transactions as the first instance of Date.

Staging Area is the later part which comes after the ODS. Here the Data is cleansed and temporarily stored before loaded into the Datawarehouse.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank