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



What is the difference between an ODS and a W/H?..

Answer / tanmay kumar meher

An ODS is an environment that pulls together, validates,
cleanses and integrates data from disparate source
application systems. Thisbecomes the foundation for
providing the end-user community with an integrated view of
enterprise data to enable users anywhere in the
organisation to access information for strategic and/or
tactical decision support, day-to-day operations and
management reporting.

The defination of Data Warehouse is as follows.
? Subject-oriented, meaning that the data in the
database is organized so that all the data elements
relating to the same real-world event or object are linked
together;
? Time-variant, meaning that the changes to the data
in the database are tracked and recorded so that reports
can be produced showing changes over time;
? Non-volatile, meaning that data in the database is
never over-written or deleted, but retained for future
reporting;
? Integrated, meaning that the database contains data
from most or all of an organization's operational
applications, and that this data is made consistent.

Difference
------------
Ods
--------
Transactions similar to those of an
Online Transaction Processing System
Data Warehouse
--------------
Queries process larger volumes of data
Ods
--------
Contains current and near current data
Data Warehouse
------------
Contains historical data
Ods
-----------
Typically detailed data only, often
resulting in very large data volumes
Data Warehouse
--------------
Contains summarised and detailed data,
generally smaller in size than on ODS

Ods
--------
Real-time and near real-time data loads
Data Warehouse
------------
Typically batch data loads

Ods
--------
Generally modeled to support rapid data
update
Data Warehouse
-----------------
Generally dimensionally modeled and
tunes to optimise query performance
Ods
------
Updated at the data field leve
Data Warehouse
---------------
Data is appended, not updated
Ods
-------
Used for detailed decision making and
operational reporting
Data Warehouse
----------------
Used for ling-term decision making and
management reporting

Ods
-----
Knowledge workers (customer service
representatives, line managers)
Data Warehouse
-------------
Strategic audience (executives, business
unit management)

Is This Answer Correct ?    12 Yes 1 No

Post New Answer

More Data Warehouse General Interview Questions

Explain what are slowly changing dimensions?

0 Answers  


Why should you put your data warehouse on a different system than your oltp system?

0 Answers  


Which kind of index is preferred in DWH?

1 Answers  


what are relationships?

0 Answers   InfoAxon Technologies,


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

0 Answers  






What are the steps to build the datawarehouse?

0 Answers  


How to get the first 100 rows from the flat file into the target?

0 Answers  


what is data validation strategies for data mart validation after loading process

1 Answers  


if source contain 10records how you identify header and footer

2 Answers   Polaris,


Explain clustering algorithm?

0 Answers  


Explain the difference between view and materialized view?

0 Answers  


Define data warehouse?

0 Answers  


Categories