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 - 5 of 5 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.
Poomari Manoharan

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

  
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.