OBIA 11g: Capturing Deleted Records of Source in Warehouse
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.1 and later
Information in this document applies to any platform.
- BI APPS 184.108.40.206.1 with OBIEE 220.127.116.11.140715
- ODI 18.104.22.168.1
- Source is PeopleSoft 9.2.
You have a scenario which deletes the job records at the source end, based on some valid scenarios. But, in your warehouse it is not capturing the corresponding data, so this results in the mismatch of data like active headcount between the source and warehouse.
1. How can you capture these deleted records in source. You have found the following documentation:
Oracle® Fusion Middleware Reference Guide for Oracle Business Intelligence Applications 11g Release 1 (11.1.1), 7 Customizing ETL Mappings for Oracle BI Applications 7.7 Marking Records as "Deleted"
But this is for Informatica with DAC. You would like a similar kind of document with a workaround for ODI.
2. You have found <Note 1903342.1> How does the Soft Delete work with OBIA 11g which clearly mentions what needs to be done.
You would like some clarification on:
a. Whether you can directly set the soft delete variables to YES and proceed with the scheduled incremental load or you should do a full load.
b. What changes need to be made and what impact it has on performance of load. Currently incremental load completes within 30 minutes.
c. Whether this can be applicable to BI APPS 22.214.171.124.1
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