Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide > Capturing Row Deletion Changes >
Delete Change Capture
In this method, Informatica identifies a row for deletion in the change capture tables. Informatica captures the deleted row information in the S_ETL_I_IMAGE table in the OLTP. The structure of this table is similar to the S_ETL_R_IMAGE table, with one additional column, OPERATION. This column stores a value identifying whether the corresponding data has been inserted (I), updated (U), or deleted (D).
The Informatica mappings that identify and create rows in the S_ETL_I_IMAGE are:
- SDEINC_IdentifyDeletes_Visibility
- SDEINC_IdentifyDeletes_pass0
- SDEINC_IdentifyDeletes_pass1
- SDEINC_IdentifyDeletes_pass2
- SDEINC_IdentifyDeletes_pass3
- SDEINC_IdentifyDeletes_pass4
The following Informatica sessions remove deleted rows from S_ETL_R_IMAGE for an ETL run so that, the S_ETL_R_IMAGE does not include rows that were deleted from the OLTP.
- SDEINC_DeleteFromImageForDeletedRecords
- SDEINC_DeleteFromImageForDeletedRecords_Visibility
- SDEINC_DeleteIncrementalImage. (Internal Use)
This is an important synchronization process because it compares the OLTP table with the S_ETL_R_IMAGE. Without this synchronization, the same rows are continuously marked for deletion for every run.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |