Siebel EIM Interview Questions

By Nicole White,2014-06-27 17:35
10 views 0
Siebel EIM Interview Questions

Siebel EIM Interview Questions

Excellent collection of Siebel EIM Interview Questions and Answers from

    web. Siebel EIM questions has been answered by siebel professionals in various forums and may not be as per your expectation and expertise. We invite you to write a small note on comments if you want to add your input in the answer.

    ; What is EIM?

    EIM is a server task that manages exchange of data between external data in interface

    tables and user data in base tables.

    ; What is User Data?

    User data only managed and populated by you. Installation populates seed data and

    repository data.

    ; What is the difference between EIM and EAI?

    EIM: It is batch mode Integration. When data volume is large then we have to go to


    EAI: It is real time Integration. When data volume is small then we have to go to EAI.

    ; How many type of Siebel Data model extensions are there?

     Standard and Custom extensions

    ; What is Archiving?

    EIM Deletes are useful for archiving old data and deleting obsolete data. During delete

    processing the deleted rows are written to interface tables from which they can be

    archived in a format allowing easy re impact if necessary.

    ; Where the user data is stored?

    The User data is stored in one or more base tables in the Siebel database. Relationship

    between the base tables relay upon PK & FK based on row ids.

    -ROW_ID is the system primary key for every base table.

    -ROW_ID is the system-generated value.

    ; What are interface tables?

    Interface tables store external data inside the Siebel database.

    These tables are:

    Staging area for data to be imported, updated merged in to base tables via EIM.

    Staging area for data exported by EIM.

    Staging area for data to be deleted in the base table using EIM’s DELETE EXACT


; What is Data Cleansing?

    During imports, EIM attempts to import data from the interface table to the base table.

    It is important to note that if the data loaded in the interface table is faulty, it will

    remain faulty in the base tables. EIM Does not perform data cleansing.

; What is data mapping?

    Data Mapping determines

    Which Siebel base table columns will store external source data

    Which interface table columns will be used to import from source to destination

; What is user key?

    PK&FK based on ROW_ID are used for system wide referential integrity. Based on

    multiple columns user keys are used to uniquely identify a row for EIM

; Why we need user key column mapping?

    User key column mapping in interface tables are used to resolve ROW_ID s for base

    tables, maintaining referential integrity.

; What is the relationship between base tables and interface tables?

    An interface tables may populate more than one base table.

    A base table may be populated by more than one interface table.

    ; What are the three important fields (mandatory columns) in interface


    IF_ROW_BATCH_NUM: Number to identify all records that should be

    processed in a batch.

    ROW_ID: Unique number to identify the record in the batch.

    (Here is the not generated ROW_ID used on base tables).

    IF_ROW_STAT: Non-Null character value which is reset during the run.

; What is the use of EIM_T columns?

    All interface tables having EIM_T columns used to hold temporary values and status

    during processing setup.

; Can you use EIM to populate added extension columns to a base table?

    Yes. But you must add extension columns to the appropriate interface table and map

    the extension columns to the base table.

; Why we set trouble shooting flags?

    Task parameters can override component level event logging to create additional

    information in the log.

    Trace Flag = 1 à Record Processing steps.

    Error Flags = 1 à Record details regarding failed rows.

    SQL Trace Flags=8 à Record summary SQL.

    Should only be done in test environment.

    Dramatically impeds EIM Performance and generate large log files

; How will you verify EIM task?

    Verify EIM Task Using

    Server Manager Logs

    SQL against the EIM and the Base tables

    Client Application to view data.

; What is mean by explicit primaries?

    Use the primary flag to set explicit primaries through EIM

    Use when the external system knows which child should be primary.

; 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


; 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 ?






; Will modifications to a BC affect an EIM import process?

    The answer should be No, Enterprise Integration Manager (EIM) works at the table


    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.

Report this document

For any questions or suggestions please email