Share

Siebel EIM Interview Question – Part I

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 EIM.
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 CLAUSE.

 

·         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

 

 

Please subscribe with us to get regular feeds of the website.

Leave A Reply

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

error: Content is protected !!