ODS table

[Former Member]

Hi Gurus,

From which table ODS updates data into a cube?

is it activa table or change log.

Thanks,

Ram

[Former Member]

hi its change log table.

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: Contains the change history for delta updating from the ODS Object into other data targets, such as ODS Objects or InfoCubes for example

The tables containing active data are constructed according to the ODS object definition, meaning that key fields and data fields are specified when the ODS object is defined. Activation queue and change log are the same in the table’s structure. They have the request ID, package ID and the record number as a key.

[Former Member]

Hi Ram,

Changelog table is used for updating data from ods to other data targets, whereas the active data and modified data are stored in active table and new data table respectively.

Hope it helps....let me know

Regards,

RV.

[Former Member]

Hello Ram,

Data targets are updated from ODS using CHANGE LOG!!

Active table stores data used for reporting.

Hope it helps.....

thanks,

[Former Member]

Hi RV/ABY,

Thanks for ur reply.

so for reporting Active table is used and for

updating to data target Change log is used.

Thanks

Ram

[Former Member]

hi ram,

There r three tables associated with ods

1.active table is the table where active data is stored in ods.The data from this table only updates in to ods

2. new data table: A table with new or modified data since the last activation

3. changelog table : a table which contains which contains the changelog for update from one ods to another ods or data target

Regards

ravi

Pls reward with pts for the answer which are useful.

Pls .dont forget to reward pts for the previous threads u had posted.

[Former Member]

Hi ram

Please go throught the following link it will give gull idea about ODS Technology

http://help.sap.com/saphelp_bw31/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

http://help.sap.com/saphelp_bw31/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

Regards,

PRK

Message was edited by: PRK

[Former Member]

Hi Ram:

ODS updates the data from active table, on which we do reporting. change log table contains all the changed records data.

please let us know if u have any any questions.

please assign points if this is helpful

kavi