EIM Delete Process Overview

• This process deletes the records from the Siebel base tables.
• Deletes records from the base table by identifying the records in the base on the basis of the user keys specified in the corresponding interface table.
• Deletes all records from the Siebel base table if the parameter DELETE ALL ROWS is specified as true. For this process the records are not populated in the interface table. Even if the records are populated on using this parameter EIM component skips these records and proceed by deleting all the rows in the given base table
• If  the DELETE MATCHES parameter is specified then only those records are deleted that matches the condition in the WHERE clause.  
• On successful deletion the IF_ROW_STAT column of the interface table will have the status as DELETED.
• EIM updates other tables with rows containing foreign keys that point to newly deleted rows.
• Deletion process will delete/Update  the corresponding records from tables where the ROW_ID of record is referred as foreign Key.
• EIM uses a combination of interface table row contents and configuration file parameter values to determine the method for selecting rows to be deleted. 

The following delete methods are supported:

• DELETE EXACT
• DELETE MATCHES
• DELETE ALL

DELETE EXACT

Delete rows in a SIEBEL base table with user key values specified in the corresponding interface table.

DELETE MATCHES

Delete rows in the base table where the contents of a named column match those specified by a WHERE clause expression in the configuration file.

DELETE ALL

Delete all rows in the base table regardless of interface table row contents or configuration file WHERE clause expressions.