Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Workforce Analytics > Process of Configuring Workforce Operations for Oracle 11i >

Enhancing Existing Mappings for U.S. Statutory Compliance

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

The final task before running the upgrade mappings involves:

1. Adding the EEO_JOB_CAT_DESC port to the corresponding staging table, TI_JOBS. (TI_EMPLOYEES already has the ETHN_GRP_DESC port, therefore no enhancement is required.)
2. Enhancing the Source Qualifier for the existing load mappings, M_I_EMPLOYEES_LOAD and M_I_JOBS_LOAD, to accommodate the added ETHN_GRP_DESC and EEO_JOB_CAT_DESC columns.

First, modify the staging table, TI_JOBS, to add port EEO_JOB_CAT_DESC. You must modify the staging tables in both the Target and Source folder, as well as in the back-end database.

To modify the TI_JOBS staging table

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In the Source folder, double-click the TI_JOBS staging table located in the IA_ORA_STAGE sub-folder to open the Edit Tables window.
3. Select Replace after dragging and dropping the table into the Warehouse Designer.
4. In the Columns tab, add a new port directly below EEO_JOB_CAT_CODE port.
5. In the new field, enter the port name of EEO_JOB_CAT_DESC, and select a data type of String (254).
6. Click OK and save changes to the repository.

   NOTE:  Open the Target folder, and repeat the preceding procedure. Please note that you must modify the corresponding staging table in the back-end database to accommodate the new port.

The next task is to modify the Source Qualifier for the load mappings M_I_EMPLOYEES_LOAD and M_I_JOBS_LOAD.

To modify the Source Qualifier in the load mapping for M_I_EMPLOYEES_LOAD

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In the M_I_EMPLOYEES_LOAD mapping, double-click the SQ_EMPLOYEES Source Qualifier.
3. In the Ports tab, add a new port directly below the ETHN_GRP_CODE port.
4. In the new field, enter the port name of ETHN_GRP_DESC, and select a data type of String (254).
5. Click OK.
6. In the Properties tab, open SQL Query field. There are two options:
   • If you have not modified the SQL statement, you can select Generate SQL and click OK.
   • If you are not using the preconfigured SQL statement, you must modify the join condition manually.
7. Validate and save changes to the repository.

To modify the Source Qualifier in the load mapping for M_I_JOBS_LOAD

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In the M_I_JOBS_LOAD mapping, double-click the SQ_JOBS Source Qualifier.
3. In the Ports tab, add a new port directly below the EEO_JOB_CAT_CODE port.
4. In the new field, enter the port name of EEO_JOB_CAT_DESC, select a data type of String (254), and click OK.
5. In the Properties tab, open SQL Query field. There are two options:
   • If you have not modified the SQL statement, you can select Generate SQL and click OK.
   • If you are not using the preconfigured SQL statement, you must modify the join condition manually.
6. Validate and save changes to the repository.

After you have modified the domain values in the upgrade mappings, and enhanced the column structure in the existing mappings, run the upgrade mappings prior to proceeding with configuring the extract mappings. For a discussion on configuring the Employees Dimension and configuring the Jobs Dimension, see About Configuring Workforce Operations for Oracle 11i. Make sure to run the mapping only once to properly reflect data.