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  >  Basics

 Print  |  
Question:  ODS and Staging

Answer: What is the difference between ODS and Staging?


November 11, 2008 05:20:41 #4
 shanavaz   Member Since: October 2008    Total Comments: 1 

RE: ODS and Staging
 

ODS, Operational Data Store is majorly different from Staging in the below
aspects:

- Existing Records in the System can get updated based on necessary instructions
& design.

- It can be used for immediate reporting if the DW is not in place.


What is Common?

- Transformation/Data check/Validation/Applying Filters/Rules can be done in
both these systems.

- They both are/can be used as a data feed for DW Loading.

     

 

Back To Question