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 template options?
What are extractors? Name a few which are used commonly in the sap bw?
can anyone tell me abt WAD navigation?
You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?
What does the program RSMDCNVEXIT check?
what are the different components in dso architecture?
What are the objects that support variables?
How the mapping is done in bw?
How do you convert from LIS to LO extraction?
When i am executing process chain ,the pc takes data into the xml file and transfer to the next process..where this xml file is stored?
what is compatable and incompaltable bojects? plz ssend to my mail noorsoft143@gmail.com i need a declinations and example thanks in advance..............
Explain about cubes?
Which datastore object is used?
How will you configure BW to load data from data stages?
Explain dash board?