Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse >

Configuring the Domain Value Set Using PowerCenter Designer

If there are no worksheet files to map the source system values to the domain values, you need to modify the values using PowerCenter Designer. For more information on configuring the domain value set with CSV worksheet files, see Configuring the Domain Value Set with CSV Worksheet Files.

Configuring the domain value set for a particular column, using PowerCenter Designer, entails one or both of the following activities:

• Mapping source-specific values to domain values
• Adding more domain values to the prepackaged set of values

Regardless of which activity you choose, the configuration occurs in the Expression transformation of the applicable Source Adapter mapplet. The following procedure shows how to configure the Expression transformation to change the domain values.

To map source values to domain values using PowerCenter Designer

1. Identify all the Siebel Customer-Centric Enterprise Warehouse table columns that use domain values.

   For a list of columns that use domain values, see the Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

2. List all of your source values that qualify for conversion to one of the domain values.
3. Map each source value to a domain value.

   If any of your source system values do not map to a prepackaged domain value, and you may modify the list of domain values, then create a list of new domain values and map your orphaned source system values to your newly created domain values.

   You cannot modify all domain value sets. Also, you must check which metrics are affected by the modified domain value set. For more information, see the Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

4. In PowerCenter Designer, open the applicable Source Adapter mapplet.
5. Open the Expression transformation.
6. Locate the applicable port's expression so that you can modify it.
7. Edit the port's expression to map your source values to the existing domain values.

   Alternately, if you want to add additional domain values, add them in this same expression.

8. Save and validate your changes to the repository.