Bookshelf Home | Contents | Index | PDF |
Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings > EIM Table Mappings to Base Tables Without User KeysSome EIM tables contain table mappings to base tables without user keys. When using these EIM tables, you should note the EIM behavior for the relevant process type as described in Process Issues for Base Tables Without User Keys. EIM Tables and Base Tables Without User KeysTable 5 lists some examples of EIM tables containing table mappings to base tables without user keys. Process Issues for Base Tables Without User KeysThis subsection describes issues that you should be aware of when performing EIM processes involving base tables without user keys. Importing Data into Base Tables Without User Keys. Import works but EIM does not check and prevent duplicate records from being imported into the base tables without user keys. If an import batch is executed repeatedly, the same records are imported repeatedly because EIM cannot check whether the records to be imported already exist in the base table without user keys. Updating Data in Base Tables Without User Keys. Update on base tables without user keys cannot work, because EIM cannot uniquely identify the record to update. Exporting Data from Base Tables Without User Keys. Exporting data from base tables without user keys is done the same way as exporting data from base tables with user keys. Deleting Data from Base Tables Without User Keys. DELETE ALL ROWS and DELETE MATCHES can be used to delete data in target base tables. If a table without a user key is the target table, then delete works as it does for base tables with user keys. In most cases, however, a table without a user key is a secondary table and its data can only be deleted with the table as a child of its parent table. NOTE: EIM_NOTE_DEL and EIM_SKLI_DEL are special EIM tables used for deleting from the S_NOTE* and S_*SKILL_IT tables, which do not have the normal U1 user key. Merging Data in Base Tables Without User Keys. Merge does not work on base tables without user keys. |
Siebel Enterprise Integration Manager Administration Guide |