Siebel Enterprise Integration Manager Administration Guide > Deleting Data >
EIM Delete Process
EIM reads information from the EIM tables and the EIM configuration file to identify rows to delete from the Siebel base tables.
During its multiple passes through the EIM tables, EIM performs the following tasks:
- EIM initializes the EIM tables for deletion.
- It applies filter logic to do one of the following:
- Select rows for deleting
- Insert EIM tables rows that correspond to matching base table rows
- Select rows with matching user keys in the EIM tables
- EIM updates other tables with rows containing foreign keys that point to newly deleted rows.
EIM provides comprehensive status information about each delete process. When the process ends, you should review this information. For further details, see EIM Delete Process.
The EIM delete function requires you to perform the following tasks:
The delete process performed by EIM is called a cascade delete. When a cascade delete is performed, all of the contents of a data structure, including all of its substructures, are deleted. In other words, the data deleted is not restricted to the base tables mapped to the EIM table that you specified in the delete process, but all child records as well. To delete data, EIM performs a sequence of tasks. Each task involves multiple passes; at least one pass is required for each EIM table included in the process. You should be very careful and specific when specifying delete criteria. For example, using the criteria "DELETE MATCHES = S_PARTY, (CREATED > xxxxx)" causes all records of S_PARTY that match this criteria to be deleted from the database.