Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Common Components of the Oracle Business Analytics Warehouse > Codes Lookup >

Configuring Extension Column Code Description Lookups

You can configure dimension and fact load sessions to perform specific lookups by editing the category of the data to be extracted from the W_CODES table and loading the code information into a target table. If the code and code name do not exist in the W_CODES table, then you must add them to the table. To configure the lookup, create a session override; do not modify the load mapping in the load mapping.

To configure sessions for lookups

1. In PowerCenter Workflow Manager, open the applicable source system configuration folder.
2. Open the Edit Tasks box.
3. In the Transformations tab, edit the SQL statement for the lookup.

   For example, you may wish to edit the following lookup:

   MPLT_ADI_SUPPLIERS.LKP_SPLR_ATTR1

4. Edit the SQL statement to use the desired code category.
5. Edit the SQL statement from 'GENERIC' to the category you wish to use for the lookup.