My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.