how to load a new column in base table from external table?

Hi

Go to Tables->Select your table
right click, you'll see the option that will modify the EIM table.
Once that done, Apply & Activate changes done on the EIM table.

EIM process:

1. Map your base table to eim table (pick an eim table that will load data to your basetable)
2. Use etl tool to load data into eim table
3. Create your ifb file that will be used to provide the relevant information to eim manager
4. Run siebel server job to call the eim object manager // islam

what is use index hints and net change in EIM?

what is use index hints and net change in EIm?

Net change parameter is used to load null values in the Base table.

If you set Net change parameter to false in the IFB file then the columns which has null value also get uploaded in the base table.

Any one pls tell me about index hints