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