Define ODS?

Answer Posted / ravikumar

An ODS object acts as a storage location for consolidated
and cleaned-up transaction data (transaction data or master
data, for example) on the document (atomic) level.

It describes a consolidated dataset from one or more
InfoSources. This dataset can be evaluated using a BEx
query.

Structure

Every ODS object is represented on the database by three
transparent tables:

Active data: A table containing the active data (A table)

Activation queue: For saving ODS data records that are to
be updated but that have not yet been activated. The data
is deleted after the records have been activated.

Change log: For updating delta from the ODS Object into
other data targets, such as ODS Objects or InfoCubes for
example.

Is This Answer Correct ?    5 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the source for FIAR extractor from R/3?

1756


What is automatic loading of similar/identical requests option?

1539


When you define aggregates, what are the available options?

512


What are the data target administration tasks?

1782


Which datastore object is used?

530






What is the use ':' as an authorization value?

523


You want to convert bex query global structure to local structure. How would you do that?

513


what are the reports used from business content in sap bw project?name them and what was the requirement?

2440


What are the steps to create classes?

1634


What are the flags for general reporting?

1506


is their any difference between bex 3.5 and bex 7.0?

3650


When you are using sap bi7.x, you can load the data to which component?

545


What are the Oracle specific tuning should be done?

1326


What are the built in javascript functions available to customize your web template?

1476


What is a repair request?

1516