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:

  • SDE_OrganizationDimension_LoadDeletedRows
  • SIL_OrganizationDimension_LoadDeletedRows
  • SDE_PersonDimension_LoadDeletedRows
  • SIL_PersonDimension_LoadDeletedRows
• Hard Deletes

  All visibility-related tables have Informatica mappings that remove deleted rows. These mappings have the following naming convention:

  • SDE_X_Party_LoadDeletedRows

    where X stands for the module like Account, Contact, Activity, and so on.

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