hi,
when we do full update then data comes from which table of ODS?(means incase when we upload data first ODS and then in to cube)
when we do init then data comes from which table of ODS?
when we do delta then data comes from which table of ODS?
pls kindly help me
thanks & regards
rashmi
Hi Rashmi,
Loading from an ODS to the cube, when you do a full load, the data is taken from the Active data table of the ODS. In the case of delta, the data is taken from the Changelog table.
Hope this helps...
There are 3 tables for ODS.
Active
active data records , Change log
stores the delta..
New--Before data gets updated into Change log it resides in new data.
From help:
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
Go thru the link..
http://help.sap.com/saphelp_bw33/helpdata/en/f9/45503c242b4a67e10000000a114084/frameset.htm
Questions and Answers:
http://help.sap.com/saphelp_bw33/helpdata/en/f9/45503c242b4a67e10000000a114084/frameset.htm
Add a comment