Oracle Incentive Compensation Analytics for Oracle Data Integrator - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2] Information in this document applies to any platform.
Goal
Problem: ETL performance with the Earning Transactions
The out of the box OICA provides incremental ETL for the open-periods. The current structure with earning fact table(cn_f_earning_txns), before loading the new transactions and update the surrogate keys of all the dimensions, it deletes all the transactions which were updated/deleted in the source EBS-OIC instance. This process creates fragmentation with volume data, and degrades the performance of sql's related to the fact table (cn_f_earning_txns). The fragmentation can be eliminated by reorganizing the database objects. But all Customers cannot allocate the time and resource for the re-organization of the fact table cn_f_earning_txns, if it is referencing 24*7.
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!