OBIA 11g How Do Soft Deletes Work For Dimension Tables in Student Information Analytics (SIA) ?
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
There is a process to soft delete rows in Fact Tables, but you cannot see how the DELETE_FLG column works on Dimension tables.
For example, delete a campus_code from the Peoplesoft source table PS_CAMPUS_TBL.
The staging table, W_SIA_CAMPUS_DS correctly does not have this row after the Load Plan run. However, the data on the actual Dimension table, W_SIA_CAMPUS_D has updated every row, except the deleted row, to the last ETL process number, even though none of the other rows had any changes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms