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 the drawbacks of ods?
How would you convert an info package group into a process chain?
Where do you find which table is currently being populated (BIW1 or BIW2)?
Is it possible to convert a standard infocube to real time infocube?
What is the use dso in bw system? What kind of data is stored in dsos
What are the different categories of infoobjects in bw system?
What is infoobject otpauth?
What is Infoset Query?
We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario
what is sid for to trasport the object along the land scape:/
Where to check the log for warning messages appearing in activation of transfer rules?
What are the steps to create classes?
Explain the usage of geo-coordinates ?
Which datastore object is used?
What are the do?s and don?ts?