Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide > Deleting Data > Editing the Configuration File for Delete Processing > Deleting from Base Tables Other Than the Target Base TableTo use the DELETE EXACT parameter to delete data from base tables other than the target base table, specify the user key columns only for a single base table for each row in the EIM table. When specifying rows for exact deletion, make sure any columns that are not necessary to specify the row to be deleted are NULL to avoid problems with deleting from the wrong base table. EIM tries to enforce this behavior by requiring other user key columns to be NULL. If a row cannot be identified as clearly referring to a row in a single base table that row will fail to be deleted. The following procedure explains how to delete data from base tables other than the target base table using the DELETE EXACT parameter with the following scenario as an example. In this example, EIM_ACCOUNT is mapped to base tables including S_ORG_EXT, S_ORG_PROD, and S_ORG_INDUST. If you want to delete data only from S_ORG_PROD, and not delete data from S_ORG_EXT or any other base tables, complete the following procedure. To delete data from base tables other than the target base table
This deletes all rows from the S_ORG_PROD table that have user keys that match the rows in your EIM table. |
![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |