SESSION SQL
Disclaimer: This post may not appeal EIM war horses but might be of some interest to newbies in EIM. There are two types of Data, the one you look up and the one you make up. EIM is the technique which is used for the later type. As per siebel Bookshelf "Siebel EIM manages the exchange of data between Siebel database tables and other corporate databases". The EIM process constitue of two major steps: 1 - The data is first copied from external source(external table, csv , excel) into the interface tables. 2 - This data from the interface tables is then loaded into predefined destination columns in the base tables using the configuration file. This configuration file, popularly known as ifb file, hosts the magical words which can be used to import, update, delete, extract, merge data. A more detailed list of paramters is available in bookshelf. One of the interesting parameters in the list is "SESSION SQL" which can perform operations after the EIM execution. This can...