Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise 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 IA_CODES table and loading the code information into a target table. If the code and code name do not exist in the IA_CODES table, then you must add them to the table. To configure the lookup, create a session override; do not modify the ADI 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.