Answer Posted / srikanth kota
definition -
An operational data store (ODS) is a type of database that's
often used as an interim logical area for a data warehouse.
While in the ODS, data can be scrubbed, resolved for
redundancy and checked for compliance with the corresponding
business rules. An ODS can be used for integrating disparate
data from multiple sources so that business operations,
analysis and reporting can be carried out while business
operations are occurring. This is the place where most of
the data used in current operation is housed before it's
transferred to the data warehouse for longer term storage or
archiving.
An ODS is designed for 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.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are Process Chains?
What is infoobject catalog?
How are dimensions optimized?
What is sap bw/bi? What is the purpose of sap bw/bi?
what is the include program name?
What is the use of real-time infocube? How do you enter data in real-time infocubes?
what do you mean by update routines
What is geographical information in the sap bw and for what purpose it is used commonly?
What happens when you use several conditions in a query?
How do you do Currency translation in SAP BW ?What are the settings that needs to be done?
When is idoc data transfer used?
is their any difference between bex 3.5 and bex 7.0?
How would you optimize the dimensions?
How do you do EURO conversion at the database level?
What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?