Share

Siebel EIM Interview Question – Part III

Latest collection of Siebel EIM Interview Questions and Answers from web. Siebel EIM questions has been answered by siebel professionals in various forums.We invite you to write a small note on comments if you want to add your input in the answer. In continuation to our last two article about Siebel EIM Interview Question please find the final article.


·         What is mean by implicit primaries?
–Allow EIM to implicitly set primaries.
–Use the external system does not know the primary.
–Sets the primary to be the child with the lowest ROW_ID.
–Mimics auto primary in the application.

 

·         How many type of Section in EIM (.ifb) files?
Two Types:  A) Header Section and B) Process Section

 

·         What is .ifb? Mention its use?
The ‘ifb’ is a configuration file, which is used when EIM Component is running. It contains information such as user name, password, process and many other parameters.

 

·         What is called an interface table and why we use interface table in EIM?
Interface table is a staging area for EIM. Data from legacy is transferred to EIM table first using non-siebel process. For this we need interface table.

 

·         How do you import List of Values?
Depends on any Hierarchies, but using EIM_LST_OF_VAL (for EIM load) import parents first then children, otherwise you will receive failure message. COM objects can also be used to import the LOVs from a flat file to the application.

 

·         How will you find the particular interface table for a base table?
— Go to Tools-> In Object Explorer select "Flat Tab".
— And select EIM Table Mapping-> Query in OBLE in Destination Table (Base Table Name) and get the corresponding EIM Table Name in Parent EIM Interface Table.

 

·         How to find the status of EIM process?
The status of EIM Process could be seen in IF_ROW_STAT in EIM Interface table.

 

·         Name the Mandatory Columns for EIM Processing ?
ROW_ID
IF_ROW_BATCH_NUM
IF_ROW_MERGE_ID
IF_ROW_STAT
IF_ROW_STAT_NUM

 

·         Will modifications to a BC affect an EIM import process?
The answer should be No, Enterprise Integration Manager (EIM) works at the table level.
Data in the EIM table columns are imported directly into the base tables. Any changes to the configuration of the BC will not affect the EIM process.

Good luck guys…

2 comments on “Siebel EIM Interview Question – Part III”

  1. Ashish Kr. Bameta Ashish Kr. Bameta Reply

     

    1 Difference between row_is & user keys
    2 Difference between Primary key & user key
    3 Can a table has more than one user Key
    4 Can we create a new User key
    5 How many entities & rows you have imported. How long will it take
    6 Parameters of IFB file
    ONLY BASE TABLE, ONLY BASE COLUMNS, etc.
    7 How to import a primay column (like primary phone)
    8 How many ways run EIM task
    9 How can we fine tune EIM task
    10 What is Parameter "SQL Trace flag"
    11 Can we create a new EIM table
    12 Steps for creating a new col in base table & corresponding col in EIM table and mapping between the two
  2. Moatasem Reply

    11- Can we create a New EIM table.
    yes we can but it is not supported in siebel
    the rest points you can find answers in siebel book shielf

    i’de like to add more interview questions:
    1- how do you use EIM with stand alone table.
    2- how do use EIM with 2 tables with relation many to many such as Contacts and Addresses
    3- what is the difference between DELETE EXACT and DELETE FITCH.
    4- delete a table and its all extentions.
    5- delete extention table only.
    6- how to use FOR UPDATE, if record was not found create new reocrd.

    Thanks,
    Moatasem El-Haj

Leave A Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!