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

Creating a Derive Mapping

Derive mappings provide additional logic between the extract and load processes. They are primarily used to modify the format of data, or to merge data from two target tables and move it into a third. The naming convention for derive mappings is M_[SOURCE]_[SUBJECT]_DERIVE.

Derive mappings are only used in special cases. However, there may be a situation that requires additional features in a mapping. In this case, you need to build an additional mapping based on your needs.

The procedure for building a derive mapping is the same as building a regular mapping. The structure of the mapping depends on the tables from which you want to derive data. The following are examples of derive mappings for SAP R/3:

• M_S_SALES_ORDLNS_LN_DERIVE

  Derives sales order line related partner and business data.

• M_S_BUSN_CONTCTS_ACCOUNT_REP_DERIVE_MASTER

  Extracts Sales representative information from SAP R/3, as shown in the following figure.

• M_S_BUSN_CONTCTS_ACCOUNT_REP_DERIVE_ORDLNS

  Extracts Account representative (order line level) information from SAP R/4, as shown in the following figure.