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 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.

 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004