Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse >

Filtering and Deleting Records

In a typical implementation, records that are deleted from your source system are not removed from the Siebel Customer-Centric Enterprise Warehouse. If you want to delete records in the data warehouse that were removed from the source system's database and archived in a separate database, you must enable the primary extract and delete mappings.

Primary extract mappings flag records that are deleted from the data warehouse. Delete mappings perform the deletion action. When enabled, primary extract and delete mappings by default look for any records removed from the source system's database. If these mappings find that the records no longer exist in that database, the mappings remove them from the data warehouse as well.

CAUTION:  It is important to note that delete and primary extract mappings must always be disabled together; you may not disable only one type.

The delete and primary extract sessions are found in each application's fact-extract and fact-load subbatches, and are stored in the [SOURCE ABBREVIATION]_[SUBJECT]_MAIN workflow.