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

Extracting Exchange Rates from a Custom Table

This task is a step in the Process for Configuring Currencies.

If you do not maintain exchange rates in your ERP tables, but instead, you maintain them in your custom tables, then you can load them into the IA_XRATES table of the Siebel Customer-Centric Enterprise Warehouse by creating a new mapping. The easiest way to create the mapping is to copy an existing exchange rate extraction and load mapping. After you copy it, you can modify the mapping to work with your custom tables.

To create new exchange rate extraction and load mappings

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Locate an existing exchange rate extract mapping.

   Copy the entire exchange rate mapping. Be sure to copy the entire set of objects—Business Components, and staging tables.

3. Reconfigure the Business Component to select the columns from your custom tables, instead of selecting them from the prepackaged tables.

   You can name and save this modified version of the Business Component as MPLT_BC1_XRATES.

4. Reconfigure the staging table to hold all the source system related columns.

   You can name and save this staging table as T1_XRATES.

5. Reconfigure the extract mapping that uses the MPLT_BC1_XRATES as the source system, and T1_XRATES as the target, and form the KEY_ID in the extract mapping.

   This mapping is the unique record identifier from the source system. However, it may be a combination of multiple columns from the source system.

6. Locate an existing exchange rate load mapping and copy the entire exchange rate mapping.

   Be sure to copy the entire set of objects—Business Components, and staging tables.

7. Reconfigure the Source Adapter MPLT_SA1_XRATES mapplet to map the data in the staging table to the ADI format.
8. Reconfigure the load mapping M_1_XRATES_LOAD with the new Source Adapter mapplet.
9. Validate any expressions or SQL statements, and then save the changes to your repository.