Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Workforce Analytics > Process of Configuring Workforce Payroll for Oracle 11i >

Improving ETL Performance for Workforce Payroll

This task is a step in the Process of Configuring Workforce Payroll for Oracle 11i.

Oracle Business Intelligence Applications is preconfigured to use the Rule Base Optimization to improve the performance of the Payroll extract mapping. Yon can change this by using the following procedure.

To improve ETL performance for Payroll

1. Open the parameterfileOLTP.txt file using Notepad in the installation directory in \OracleBI\DAC\Informatica\parameters\input.
2. Locate the sections [SDE_ORA_PayrollFact] and [SDE_ORA_PayrollFact_Full].

   For example, the file might contain the following sections:

   [SDE_ORA_PayrollFact]

   $$DATASOURCE_NUM_ID=2

   $$TENANT_ID=DEFAULT

   $DBConnection_OLAP=PARAM_OLAP

   $DBConnection_OLTP=PARAM_OLTP_ORA11I

   mplt_BC_ORA_PayrollFact.$$hint1=/*+ RULE*/

   ...

   [SDE_ORA_PayrollFact_Full]

   $$DATASOURCE_NUM_ID=2

   $$TENANT_ID=DEFAULT

   $DBConnection_OLAP=PARAM_OLAP

   $DBConnection_OLTP=PARAM_OLTP_ORA11I

   mplt_BC_ORA_PayrollFact.$$hint1=/*+ RULE*/

   ...

3. Change the value of the database hint, as required (highlighted in bold above).
4. Save and close the file.