Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an ODS and a W/H?
- 1 Answers
- 13434 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain what are the different types of join operations?
if you use oracle sql*loader , how do you transform data with it during loading?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is operational data store (ods)?
Explain degenerate dimension table?
What are the different types of data warehousing?
What is the goal of optimizer?
What is degenerate dimension table?
What are the approaches used by optimizer during execution plan?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
How can we run the graph? What is the procedure for that?
What are the advantages of query studio compared to report studio?
What is index awareness in universe?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
