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
How do you debug user exit?
How would you change the default template?
What is the use of infocube in bw system?
What is the conversion routine for units and currencies in the update rule?
What are the options when defining aggregates?
What are the report-relevant settings in the hierarchy maintenance?
Explain the architecture of the sap bw system?
What are the parameters available in user exit for enhancing master data?
What are the different type of infoset joins?
What is the use of rollup?
What is the process chain and when you can use the same in the data warehouse?
Define the steps necessary to set up CO-PA for BW?
What is the use ':' as an authorization value?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
what are the drawbacks of cubes?