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

Configuring the Exchange Rate Type

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

The column XRATE_TYPE_CODE in the table IA_XRATES identifies a specific type of exchange rate. Data loaded from various sources have different types of exchange rates; thus, there can be different values for the XRATE_TYPE_CODE column.

If an exchange rate is not supplied to convert an amount to a different currency, then the ADI performs a lookup to retrieve an exchange rate from the IA_XRATES table. The lookup that is retrieved is based on the specified exchange rate type. Each load mapping has the default exchange rate type M. However, depending on the source system, the Siebel Customer-Centric Enterprise Warehouse has a prepackaged SQL statement in the session to extract a default exchange rate type that is applicable to the corresponding source. Thus, for Oracle 11i load sessions, there is a SQL statement that requests the exchange rate type Corporate instead of M.

If you would like to use an exchange rate type other than the prepackaged statement, then you must edit the SQL statement in the applicable session.

To override the default exchange rate type

1. In PowerCenter Workflow Manager, open the source system configuration folder.
2. Open the applicable session to open the Edit Tasks box.
3. In the Transformations tab, edit the SQL statement for the exchange rate lookups.
4. Change the exchange rate type by editing the following SQL statement fragment:

   WHERE XRATE_TYPE = 'Corporate'

   For a list of exchange rate type codes, see your source system's options.

5. Click OK.

NOTE:  You need to perform these steps for each fact load for which you wish to configure the exchange rate information.