Define ODS?

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


Please Help Members By Posting Answers For Below Questions

List the steps to configure sd and mm for bw.

497


If you are asked to change the way tables are displayed in web reporting how would you do this?

1431


What is update mode for master data?

1659


What are the steps to create DB connect?

1437


What is CO-PA retraction?

1687






iam looking for some scenarion on reporting concepts like - replacement path,customer exits, all types of variables. plese send me some important links and materials. so it will be helpful for me. thanks in advance

1458


I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is

948


What do you mean by the term rollup in the sap bw?

541


how bw was found

1380


What is the difficulty you have faced in the BW in your overall experience?we don't want common things,we need some difficult concepts what u have faced(in past Experience)?

1486


What is the option of ?pause Automatic Refresh??

1666


How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?

500


What is the procedure to implement structural authorization in BW?

1806


What are the parameters available in user exit for enhancing master data?

1519


What are intervals?

1514