Mapping your external data to EIM tables and then to the base tables is not a difficult process, but if not done using a procedural approach or not done carefully can lead to a waste of time and efforts and becomes frustrating sometimes. So, here’s the step by step procedure to insert data into your Siebel base tables so that you never miss any link :
1. For the base table, make a list of all the user keys and required columns(excluding system columns).
2. Make the list of all columns(from base table) where you need to put the data from your external data source.
3. Go to Siebel Tools and choose the interface table for your insert. Query for the base table name at Target Table in EIM Interface tables. Probably you will find a lot of tables can populate data in your base table, but choose the most obvious one(e.g. EIM_PROD_INT for S_PROD_INT).
4. Go to EIM table mapping, you will see that the EIM table can insert data in many base tables, choose your base table from the list and go to its attribute mapping.
5. Here you’ll find the list of EIM data columns that are mapping to base table columns(which you want to populate). Make a note of all those columns.
6. Using a simple database insert statement, populate data into the EIM table.
7. Make sure the columns combination that makes the user key have unique combination of data for each row you are inserting.
8. Make and run the insert ifb file.