Handling Siebel Base Tables with no user keys during EIM:
Some base tables like Note tables do not have user keys. Since user keys play a vital role in migration of data using EIM, the EIM behavior is significantly different in case of Base Tables without user keys.
For such tables, although IMPORT and EXPORT processes work, but Merge process does not work. The DELETE process, when using DELETE MATCHES and DELETE ALL ROWS parameters, works fine, but does not work with DELETE EXACT parameter. This is because the EIM process cannot identify the rows to delete, in the absence of user keys.
However, Siebel 7.5.x versions have made deletion of data from Notes tables, using a special EIM, EIM_NOTE_DEL. The EIM_NOTE_DEL interface table should only be used to delete notes from the S_NOTE_* tables. To use it, users need to populate ROW_IDs of records to be deleted into corresponding columns in the interface table and then use DELETE EXACT to delete them.
Things to keep in mind when performing EIM processes involving base tables without user keys:
For such tables, although IMPORT and EXPORT processes work, but Merge process does not work. The DELETE process, when using DELETE MATCHES and DELETE ALL ROWS parameters, works fine, but does not work with DELETE EXACT parameter. This is because the EIM process cannot identify the rows to delete, in the absence of user keys.
However, Siebel 7.5.x versions have made deletion of data from Notes tables, using a special EIM, EIM_NOTE_DEL. The EIM_NOTE_DEL interface table should only be used to delete notes from the S_NOTE_* tables. To use it, users need to populate ROW_IDs of records to be deleted into corresponding columns in the interface table and then use DELETE EXACT to delete them.
Things to keep in mind when performing EIM processes involving base tables without user keys:
- IMPORT (Insert): 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 will get imported repeatedly because EIM cannot check whether the records to be imported already exist in the base table without user keys.
- IMPORT (Update): Update on base tables without user keys cannot work, because EIM cannot uniquely identify the record to update.
- EXPORT: Exporting data from base tables without user keys is done the same way as exporting data from base tables with user keys.
- DELETE: 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.
- MERGE: Merge does not work on base tables without user keys.