Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Difference between ODS and Staging

Answers were Sorted based on User's Feedback



Difference between ODS and Staging..

Answer / harshad

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 Correct ?    28 Yes 14 No

Difference between ODS and Staging..

Answer / sunil

ODS means operational data store which supports operational
monitoring,data is
volatile,current,detailed,subjectoriented and integrated.

Staging is temperary storage location which is used for
processing the data.
staging area cleans operational data before loading the
data into Dw.

Is This Answer Correct ?    16 Yes 3 No

Difference between ODS and Staging..

Answer / pravin

Operational Data store is a subject
oriented,integrated,current,volatile collection of data
used to support the tactical decision making process for
the enterprise. It is the central point of data integration
for busienss management,delivering a common view of
enterprise data.
In Staging Area you are carried out ETL operations as per
your business logic in order to fetch processed information
into data ware house.

Is This Answer Correct ?    8 Yes 12 No

Difference between ODS and Staging..

Answer / kalpana

1. ODS is close to the source. We can say it is a replica
of source system.
While the staging area is a replica of the target DW.

2. The dimention and fact will come into picture here in
staging.

3. We are doing the Transformations in staging schema
before loading it to the target.

4. We integrate different ODS source systems into the
staging area and not in the ODS.

Is This Answer Correct ?    15 Yes 21 No

Post New Answer



More Data Warehouse General Interview Questions

What is prompt types of prompts?use of prompts syntax of prompt?

0 Answers  


What is the difference between a W/H and an OLTP application?

5 Answers  


What are the different types of scd's used in data warehousing?

0 Answers  


How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers   IBM,


Explain what is full load & incremental or refresh load?

0 Answers  






Explain clustering algorithm?

0 Answers  


What is the difference between narmal load and bulk load?

1 Answers  


What is the difference between agglomerative and divisive hierarchical clustering?

0 Answers  


What is the function of etl when used in data warehousing?

0 Answers  


What is data stream and data adaopter?

0 Answers  


Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

1 Answers  


Explain piconet?

0 Answers  






Categories