SpandanaMohan

 Profile Answers by SpandanaMohan 

• May 18th, 2008

 

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.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 10th, 2008

 

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.

sagarikaka

 Profile Answers by sagarikaka 

• Oct 31st, 2008

 

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.

shanavaz

 Profile Answers by shanavaz 

• Nov 1st, 2008

 

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.

prat4all

 Profile Answers by prat4all 

• May 25th, 2009

 

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.