Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Capturing Row Deletion Changes >
Delete Propagation
In this method rows that are identified as deleted are handled in the data warehouse tables. A deleted row can be flagged as deleted (known as a soft delete) or actually deleted from a data warehouse table (known as a hard delete).
- Soft Deletes
The soft delete propagation is provided for the Person and Organization dimensions. The relevant Informatica mappings are:
- Hard Deletes
All visibility-related tables have Informatica mappings that remove deleted rows. These mappings have the following naming convention:
NOTE: To build additional soft or hard deletes, the Informatica mappings can be used as templates. See Technical Note 420, located on SupportWeb, for details.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |