How to identify records changes in PS_COMPENSATION

Question

We use OBIA, PeopleSoft 9.0 and haven't implemented Golden Gate. We want to be able to do Incremental Load custom ETL for PS_COMPENSATION into a Fact Table. PS_COMPENSATION itself have no timestamp (LASTUPDDTTM). How we identify records changes? Is there any table that would be affected, in term of timestamp, if we make changes in PS_COMPENSATION? Any workaround?

A little background, our main/original goal is to flatten out  a few  compensation rate codes into measures in W_WRKFC_EVT_MONTH_F (extend the fact table). Because we cannot differentiate records changes, we take the whole PS_COMPENSATION,  the process takes such a long time.

Thank you for your time and helo

user2300696 · Answer

Thank you so much for the input.

For time being, I decide just to do Full Load every time, because it doesn't take really long.

Bec_Wagner · Answer

Peoplesoft has other tables that do not have last update DTTM. There are two Oracle recommended work arounds if you aren't using OGG. You can use a database trigger or a materialized view. For an example, see Configuring Incremental Extract for Projects Facts for PeopleSoft

SriniVEERAVALLI · Answer

It would be nice to have a column for LASTUPDDTTM