Oracle Incentive Compensation Analytics - Partition Earning Fact
Last updated on DECEMBER 10, 2016
Applies to:
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
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