Creating EIM Table Mapping for Standalone Table (No User Keys)

Requirement: Load data from flat file to a custom standalone table using siebel EIM.This Table should not allow duplicate records and has unique records based on col1,col2,col3(It just an example).

Solution: Follow below steps to create EIM mapping to an existing EIM table.

1. Create new standalone table CX_TSET_TBL using new Table wizard in siebel tools. This wizard creates  seven system columns by default.
2. Create new columns COL1, COL2, COL3, COL4 with Type = Varchar (30).
3. Create a New Index with below propeties.
•  Name = CX_TEST_TBL_U1
• Type = "User Key"
• Unique = "Y" (This Property makes the user to enter unique data  through UI)
• User Primary Key = "Y" The Property is used by EIM to enforce uniqueness on this index.
4. Add columns COL1,COL2,COL3 to the index created in step3. This is part of the requirement to enforce EIM to find unique records in Target table. This is equivalent to the user keys of the base table.
5. Run the EIM mapping to standalone table created in step1 to the sutiable EIM table with steps mentioned in bookshelf. It will create columns in EIM table and maps those columns to the target standalone table. It also create a user key on EIM table with the 3 columns(COL1,COL2,COL3) and IF_ROW_BATCH_NUM.
6. Write EIM scripts to load data.

Once you complete above steps, you can run EIM job on custom table. EIM will take care of the uniqueness of records and loads the data. It supports INSERT,UPDATE and DELETE operations.