Skip to Content
author's profile photo Former Member
Former Member

ods tables

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 13, 2006 at 05:36 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 05:40 PM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.