Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Integrating Additional Data > Creating New Mappings >

Creating a Codes Mapping

To write new codes to the IA_CODES table, you need to design a codes mapping to extract data from the source and load it into the IA_CODES table. Codes mappings have the following five objects, as shown in Figure 50:

• Business Component mapplet (MPLT_BC[SOURCE_VARIABLE]_CODES_[SOURCE])
• Expression transformation (EXP_CODES_[SUBJECT])
• Source Adapter mapplet (MPLT_SA[SOURCE_VARIABLE]_CODES)
• ADI mapplet (MPLT_ADI_CODES)
• IA table (IA_CODES)

  Figure 50. Codes Mapping

All codes mappings have the following three objects in common:

• Source Adapter mapplet
• ADI mapplet
• IA table

What makes each codes mapping unique are the remaining two objects—the Business Components mapplet and the Expression transformation. Therefore, when creating your new codes mapping, you can copy any codes mapping that comes from the same source and then change the Business Component mapplet and the Expression transformation.

NOTE:  Not all codes mappings require an Expression transformation.

To create a new codes mapping

1. In PowerCenter Designer, open the applicable source configuration folder.
2. Select Tools > Mapping Designer.
3. Copy any existing codes mapping into Mapping Designer that has the same source as the one you want to create.

   By using an existing codes mapping you can avoid recreating the Source Adapter. Rename the codes mapping using the appropriate naming convention. For a list of naming conventions, see the Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

4. Delete the mapping's existing Business Component mapplet and, if applicable, Expression transformation.

   You need to create a new Business Component mapplet and Expression transformation for your new mapping.
5. Create a new Business Component mapplet that includes a source definition, Source Qualifier, and mapplet output object (MAPO).

   For more information on creating a new Business Component, see the discussion on creating a new Business Component in Process of Creating and Modifying Business Adapters.

6. Drag the new Business Component mapplet into the mapping in Mapping Designer.
7. In the new codes mapping, create an Expression transformation for the Business Component mapplet.

   In this expression, you need to set the new category.

8. This category is the descriptive name of the type of code you are trying to create.
   1. Connect the detached ports in the new Codes mapping by first connecting the Business Component mapplet's output ports to the Expression input ports.
   2. Then, connect the Expression transformation output ports to the Source Adapter input ports from the mapping you copied in Step 3.

      The remaining output ports of the Source Adapter, as well as the input and output ports of the ADI, are already connected from this copied mapping.

9. Save your changes to the repository.