Siebel Data Warehouse Installation and Administration Guide > Customizing the Siebel Data Warehouse >

Standard Templates for Siebel Data Warehouse Customizations

This section describes the standard templates.

CustomTemplateSDE_PersonDimension

Using the SDE mapping, the ATTRIB_02 column of the extension stage table (W_PERSON_DSX) is populated with the value from S_CONTACT.RACE source column. This is a straightforward mapping. The different transformations are the following:

• SQ_S_CONTACT. The SQL in the SQL override section contains the link to the view created by the DAC so that only the incremental data is captured.
• EXPTRANS. The lookup (LKP_DATASOURCE_NUM_ID) obtains the DATASOURCE_NUM_ID from the W_PARAM_G table. The W_PARAM_G is populated in the beginning of the ETL by the DAC. Note that all the system columns are populated in addition to the attrib column. The ATTRIB_01 column is populated with the string Contact, because the combination of INTEGRATION_ID, DATASOURCE_NUM_ID, and CONTACT_TYPE is used to look up the ROW_WID value. In most of the dimensions, only the INTEGRATION_ID and DATASOURCE_NUM_ID values are used for this purpose.

CustomTemplateSIL_WaveDimension

Using the SIL mapping, the ATTRIB_02 column of the final extension table is populated with the person dimension (W_WAVE_DX). The different transformations are the following:

• SQ_W_WAVE_DSX. There is no SQL in the override. It is a straight query from W_PERSON_DSX table that has been populated with incremental rows.
• LKP_W_WAVE_D. Looks up the W_WAVE_D table to get the ROW_WID for the row.
• LKP_W_WAVE_DX. Looks up the target table to find out whether to insert or update the row. This information is used by the update strategy.
• EXPTRANS. Used to get the Insert/Update flag and ETL_PROC_WID by using the lookup LKP_ETL_PROC_WID from the W_PARAM_G table. This table is populated in the beginning of the Refresh Siebel DW session.
• FILTRANS. Passing only those rows that have entry in the parent dimension table.
• UPDTRANS. Insert or updates a row based on the flag.