OBIA 11g How Do Soft Deletes Work For Dimension Tables in Student Information Analytics (SIA) ? (Doc ID 1918487.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Goal

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.
 

Solution

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