Siebel EIM Interview Questions and Answers

1/14/2011 No Comment

Siebel EIM questions has been answered by Siebel professionals in various forums.

What is EIM?
Answer : 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?
Answer : User data only managed and populated by you. Installation populates seed data and repository data.

What is the difference between EIM and EAI?
Answer : 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?
Answer : Standard and Custom extensions

What is Archiving?
Answer : 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?
Answer : 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?
Answer : 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?
Answer : 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?
Answer : 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?
Answer : 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
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer