Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows > Updating Siebel Transactional Database Schema Definitions > Creating Delete TriggersThe 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, there are additional source tables that need to have delete triggers created in the Siebel transactional 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. 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 database administrator.
|
![]() |
![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide |