Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Planning Your Warehouse Configuration Project > Data Warehouse Configuration Stages >

Configurable Objects in the Load Mapping

Load mappings are useful in transforming and porting data from the staging table to a base fact or dimension table. Within each load mapping, you find the following objects—Source Qualifier transformation, Source Adapter mapplet, Analytic Data Interface (ADI) mapplet, and target table or tables.

You can configure the Source Qualifier transformation to filter records being loaded into the Siebel Customer-Centric Enterprise Warehouse target table.

The Source Adapter mapplet in the load mapping is where you usually find the source-dependent transformations. This is the last, and preferred, stage at which you can perform source-dependent transformations.

You can configure the Source Adapter mapplet to do any of the following tasks:

• Transform source data so that it becomes source-independent. For example, it maps some source values to the Siebel Business Analytics domain values.
• Provide values for dimension class table types, such as COMPANY as the business location type for the MPLT_SAS_BUSN_LOCS_COMPANY data.
• Load exchange rates and currency codes, instead of performing lookups to retrieve them.
• Set the dimension IDs in fact loads so that it can resolve the dimension keys.
• Set the Type 2 flags.
• Convert positive values to negative values.

The ADI mapplet in the load mapping must not be configured at the mapping level. Instead, changes must be made at the session level, using an SQL statement. The types of SQL statements include redirecting lookups to dimension, code, exchange rate, and custom-built dimension tables. The target tables of a load mapping can vary. If the table is a dimension load mapping, and Type 2 functionality has been enabled, you usually have two instances of the IA_* target table:

• One instance for inserting new records
• One instance for updating records

You also have an OD_* load control table. If the table is a fact load mapping, you usually have one IA_* target table and an OD_* load control table.