Skip to Content
Former Member
Apr 17, 2006 at 08:09 AM

History tracking in ODS


Hello Gurus,

I have ODS1 and ODS2. ODS1 is overwrite and ODS2 has timestamp in its key so there is no overwrite. ODS1 updates ODS2. I would want ODS2 to be updated by records contained in ODS1 change log only. Afterwards, I want to be able to report on changes to characteristic values listing which characteristics have changed and their original values and new values and also when the characteristics changed. Since change log is not available for reporting, how can I model this reporting requirement. Any suggestions are will be greatly appreciated.