Checking Delete Results

When a delete process ends, you should carefully check the results to verify that data was successfully deleted. During each process, EIM writes comprehensive status and diagnostic information to several destinations.

EIM uses a special column named T_DELETED_ROW_ID in the EIM tables. EIM writes the ROW_ID of each deleted base table row to this column.

To view a list of deleted base table rows

• Query the appropriate EIM table for rows whose IF_ROW_BATCH_NUM equals the batch number for the delete.

  The value of T_DELETED_ROW_ID identifies deleted rows.

If error flags, SQL trace flags, or trace flags were activated for the EIM process, you can also use the trace file to view the results of the EIM process. For more information on viewing the trace file, see Viewing the EIM Log File.

EIM Deletes and Audit Trail

When EIM is used to delete base table records, any corresponding Audit Trail table (S_AUDIT_ITEM) records associated with those base table records will also be deleted, even when S_AUDIT_ITEM is no explicitly defined on the EIM Interface Table Repository Object.

For example, when deleting an Employee record using EIM_EMPLOYEE, Audit Trail records related to that Employee, such as those on Account, Contact, or other objects that Employee may have touched are also deleted.

If this behaviour is not desired for a given EIM DELETE operation, add the statement DELETE ROWS=S_AUDIT_ITEM, FALSE to the IFB configuration file used by that EIM job.