GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing

 Print  |  
Question:  Staging and Operational Data Store

Answer: What are Staging and Operational Data Stores and what is their difference?
Why does one need staging and why does one need ODS?
What will happen if they are not there?
Who and how is it decided that a staging or ODS is needed?
Which comes first staging or ODS?


August 08, 2009 04:32:21 #2
 sixto.dsilva   Member Since: March 2008    Total Comments: 56 

RE: Staging and Operational Data Store
 

Staging and Operational Data Store
What are Staging and Operational Data Stores and what is their difference?
An operational data store (or "ODS") is a database designed to integrate data from multiple sources to make analysis and reporting easier.

Staging areas are used in databases as a place to store temporary data for import. By filling this staging tables with import data you can check and alter this data before committing it to the final production datatables.

I think previous answers are perfectly valid

Why does one need staging and why does one need ODS?

Check above answer.

What will happen if they are not there?
Answer lies above.

     

 

Back To Question