GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 106 of 113    Print  
ODS and Staging
What is the difference between ODS and Staging?


  
Total Answers and Comments: 5 Last Update: May 25, 2009     Asked by: raja_vnb 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: SpandanaMohan
 
An operational data store (ODS) is a type of database often 
used as an interim area for a data warehouse. Unlike a data
warehouse, which contains static data, the contents of the
ODS are updated through the course of business operations.
An ODS is designed to quickly perform relatively simple
queries on small amounts of data (such as finding the
status of a customer order), rather than the complex
queries on large amounts of data typical of the data
warehouse. An ODS is similar to your short term memory in
that it stores only very recent information; in comparison,
the data warehouse is more like long term memory in that it
stores relatively permanent information.

But in staging we are storing current as well as historic
data. This data might be a raw and then need cleansing and
transform before load into datawarehouse.


Above answer was rated as good by the following members:
mri_sonam
May 18, 2008 11:36:29   #1  
SpandanaMohan Member Since: January 2008   Contribution: 12    

RE: ODS and Staging
An operational data store (ODS) is a type of database often 
used as an interim area for a data warehouse. Unlike a data
warehouse which contains static data the contents of the
ODS are updated through the course of business operations.
An ODS is designed to quickly perform relatively simple
queries on small amounts of data (such as finding the
status of a customer order) rather than the complex
queries on large amounts of data typical of the data
warehouse. An ODS is similar to your short term memory in
that it stores only very recent information; in comparison
the data warehouse is more like long term memory in that it
stores relatively permanent information.

But in staging we are storing current as well as historic
data. This data might be a raw and then need cleansing and
transform before load into datawarehouse.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 10, 2008 10:29:05   #2  
sixto.dsilva Member Since: March 2008   Contribution: 59    

RE: ODS and Staging
According to Kimball a Data stagging is a major process that includees among others the following subprocesses. Extraction transformation loading and indexing and quality assurance checking.ODS is normal processing system where all the daily transaction are done. Please correct me if i am wrong.
 
Is this answer useful? Yes | No
October 31, 2008 06:41:24   #3  
sagarikaka Member Since: April 2008   Contribution: 7    

RE: ODS and Staging

Data Staging is also called 'Operational Data Store'(ODS). It is a data holding place where the data which is extracted from all the data sources are stored. From the staging area the data is loaded to DWH. Data cleansing takes place in this stage.


 
Is this answer useful? Yes | No
November 01, 2008 05:20:41   #4  
shanavaz Member Since: October 2008   Contribution: 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.


 
Is this answer useful? Yes | No
May 25, 2009 04:47:57   #5  
prat4all Member Since: March 2008   Contribution: 1    

RE: ODS and Staging
ODS keeps the transactional data from where direct reporting is possible. The data in ODS can be partly denormalized.

Staging area is the exact replica of the transactional database which acts as a source for datawarehouse processing.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape