What is the Difference between a ODS and Staging Area

Showing Answers 1 - 5 of 5 Answers

mithunmca

  • Mar 28th, 2007
 

 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.

siraj khan

  • Aug 9th, 2007
 

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. 

  Was this answer useful?  Yes

Vamshidhar

  • Jan 9th, 2009
 

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.

  Was this answer useful?  Yes

ram

  • Jun 11th, 2013
 

Yes, ODS is a Open Data Source where it contains real time data (because we should apply any changes on real time data right..!) so dump the real time data into ODS called Landing area later we get the data into staging area here is the place where we do all transformation.

  Was this answer useful?  Yes

Poomari Manoharan

  • Jul 2nd, 2014
 

ODS is nothing but the Operational Data Store which holds the data when the business gets started. It means , it holds the history of data till yesterdays data(depends upon customer requirement). Sometimes, it holds the real time data also.
Staging is the area before ODS which holds only 15 / 30 / 45 / 90 days data based on customer requirement. In some of the project , staging is used as Pre-Production data. That depends.
Hope this might be helpful

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions