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