OBIA - Performance Issue While Running SIL_APTransactionFact with EBS

In OBIA 7.9.6.4 with EBS:

• Informatica Mapping 'SIL_APTransactionFact runs incrementally every day and used to take approximately 15 mins.
• But now SIL_APTransactionFact is taking over 3 hours.

Cause

The Prune Days DAC Parameter was set to the default value of '30', causing millions of W_AP_XACT_F records to be processed in the LKP_W_APP_XACT_F Lookup 

Solution

Please Note the following:

• 'Prune Days' is used for Siebel data, where they have Remote Field Users who might only 'sync' up their laptop or data once a month. Therefore they may have lost old data created remotely weeks earlier.
• In EBS, there is no concept of a Remote Field User having to work offline and then 'sync up' at a later date, so this functionality is basically redundant in EBS environments.

 To resolve this issue, please set the Prune Days DAC Parameter to '1'.

With the W_AP_XACT_F Lookup processing less data during an Incremental Load, it will now process much less data and complete much faster.