Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Using the DAC's Data Warehouse Configurator Wizard >

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 OLTP database in order to track deleted records.

The change capture mechanism from this release onwards will use delete triggers to be able to capture deleted rows information. Out-of-the box ETL captures deletes for W_ORG_D and W_PERSON_D. The source tables for these S_ORG_EXT, S_CONTACT and S_PRSP_CONTACT need to have delete triggers created to be able to track deleted records. Such records are identified by setting the ACTIVE_FLG column to D.

For vertical applications, there are additional source tables that need to have delete triggers created in the Siebel OLTP database to be able to track deleted records. These are 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.

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 database administrator.

Before creating delete triggers, you need to create the appropriate database connections. For instructions, see Creating Database Connections.

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 database where the triggers will be created.
5. (Optional) Select the Include optional triggers check box to include optional tables.
6. Click Start.

Bookshelf Home | Contents | Index | Search | PDF