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
You want to see if the execution of a query has been slow or fast. How would you do that?
What are the load process and post processing?
What are the restrictions DB connect?
What is the use of rollup?
Give an example for this URL command?
is their any difference between bex 3.5 and bex 7.0?
I have cube.for cube data coming from 3dso's.in one dso having special chars.in cube you got special char error.how u can resolve this?
How would you convert an info package group into a process chain?
Give an example of master data documentation?
what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
What are the different types of infocube?
What is persistence mode in cache?
Can you tell something about the data ware-house hierarchy?
How do you do EURO conversion at the database level?
Describe your experience with the design and implementation of standard & custom infocubes.