Siebel Business Analytics Applications Installation and Administration Guide > Installing and Configuring Analytics Applications on Windows > Updating Siebel Transactional Database Schema Definitions >

Creating Delete Triggers

The change capture process in Siebel Data Warehouse uses delete triggers to capture deleted records. The preconfigured ETL process captures deleted records for tables W_ORG_D and W_PERSON_D. The source tables for W_ORG_D and W_PERSON_D are S_ORG_EXT, S_CONTACT, and S_PRSP_CONTACT; these tables need to have delete triggers created in the Siebel transactional database in order to track deleted records. Such records are identified by setting the ACTIVE_FLG column to D.

For vertical applications, the following additional source tables need to have delete triggers created in the Siebel transactional database: S_MDF_TXN, S_ASGN_GRP_POSTN, S_ASGN_RULE_ITEM. The preconfigured ETL process captures deleted records for W_FUND_F and W_ALIGNMT_DH.

In Siebel Data Warehouse, preconfigured visibility tables are inactivated. If your organization is going to use any of the visibility-related data warehouse tables, you need to activate them in the Tables tab of the Design view of the DAC client. If you activate visibility tables, you should also create delete triggers on the optional tables.

The preconfigured SIA Account and Contact visibility tables are activated by default for vertical applications. If your organization is not going to use any of the visibility tables, you need to inactivate them in the Tables tab of the Design view in the DAC client.

When creating delete triggers using the Data Warehouse Configurator, you have the option of including the optional tables for which you want to enable the delete triggers. You also have the option of having the trigger statements be directly executed or being written to a file, which can then be executed by a database administrator.

To create a delete trigger

1. From the DAC menu bar, click Tools > ETL Management Configure.
2. Select the Create Delete Triggers in Transaction Database check box.

   The Delete Triggers tab is active.

3. Select Create Triggers.
4. Select the transactional database where the triggers will be created.
5. (Optional) Select the Include optional triggers check box to include optional tables.
6. Click Start.