Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to identify records changes in PS_COMPENSATION
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
Answers
-
It would be nice to have a column for LASTUPDDTTM
0 -
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
0 -
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.
0