GeekInterview.com
Series: Subject: Topic:
Question: 32 of 76

What is the Difference between a ODS and Staging Area

Asked by: Interview Candidate | Asked on: Mar 27th, 2007
Showing Answers 1 - 4 of 4 Answers
mithunmca

Answered On : Mar 28th, 2007

View all answers 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
siraj khan

Answered On : 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. 

  
Login to rate this answer.
Vamshidhar

Answered On : Jan 9th, 2009

View all answers by Vamshidhar

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.

  
Login to rate this answer.
ram

Answered On : 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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.