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
hierarchies are not there in bi?why
What is the use of navigational attributes?
What is the importance of 'start routine' in update rules?
What is the library?
List the steps you would take to create your dashboard in bw.
How do you create event chains?
Is it possible to create aggregates for cumulative?
When you are using sap bi7.x, you can load the data to which component?
Can any 1 plz tell me How to identify the missing delta's to run the repair full request,and vat are the extractors used in lo cockpit,if i use filter on condition which 1 will execute first?,
How does delta update mechanism work in ods?
In compression level all requests are becoming zero which data is compressing tell me detail
What happens when you use several conditions in a query?
Differentiate between v1, v2, v3 jobs in extraction.
List the steps to do the creating classes in sap-bw
What are the data sources supported?