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

Creating a Source Adapter Mapplet

The majority of all source-specific transformations occur in the Source Adapter mapplet; source-independent transformations generally take place in the Analytic Data Interface (ADI). The Source Adapter mapplet converts source-specific data elements that come from a staging table into those data elements required by the source-independent ADI.

Figure 22 illustrates the three components of the Source Adapter mapplet that allow transformations of data to occur. The three components are Mapplet Input (MAPI), Expression transformation (EXP), and Mapplet Output (MAPO).

Figure 22. Input, Expression, and Output Ports of a Source Adapter Mapplet

In Figure 22, notice that the MAPI receives data from the Staging table. This data is passed through ports prefixed with INP_. If the input data is transformed, the data is passed to the Expression transformation (EXP) as input only. After the data is transformed, it is output through a new port, which is prefixed with EXT_. If the data is not transformed, it comes in as input-only and leaves through an output-only port.

If you want to add a new transformation, you must add a new port to contain the expression that is used to transform the data.

To add a new port to the Source Adapter mapplet

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Open the applicable Source Adapter mapplet.
3. Double-click the MAPI component of the mapplet, and add a new input port following the INP_* naming convention.
4. Copy the new input port from the MAPI to the Expression transformation.
5. Connect the new port from the MAPI to the Expression transformation.
6. In the Expression transformation, uncheck the Output indicator for the new input port; you use the value from this port in an transformation expression.
7. Perform any necessary transformations within the Expression transformation.

   The transformed data is passed out of an EXT_* output-only port.

8. Connect the port from the Expression transformation to the MAPO.

   Figure 22 shows that the ports in the Mapplet Output match the input ports of the ADI mapplet exactly, with the exception of new ports. If you are adding a new port, you must connect it to an extension column, because you cannot add the new port to the ADI.

9. Validate and save your repository.