Siebel EIM Interview Questions, Answers and Explanation.

7/10/2012 No Comment

Siebel EIM Interview Questions, Answers and Explanation.

Can you tell me what are the different processes in EIM?
Answer : Import, Export, Delete and Merge.

Can we do update through EIM? If so, what process should be used to do update?
Answer : Yes. The process is Import.

How does EIM identify if the record is for insert or for update?
Answer : Through user keys. If the record for the same user key exist, then EIM does an update else insert.

Can we generally update user keys through EIM?
Answer : No. But for Account (S_ORG_EXT table) and Product (S_PROD_INT table) we can even update user keys.

What are the columns must be populated in any EIM table before running EIM task?
Answer : ROW_ID, IF_ROW_STAT and IF_ROW_BATCH_NUM.

What are the different values that we may get in IF_ROW_STAT column once EIM run is over?
Answer : IMPORTED, DUP_RECORD_EXIST, PARTIALLY_IMPORTED, FOREIGN_KEY, PICKLIST_VALUES, REJECTED, AMBIGUOUS etc.

When do we get ‘AMBIGUOUS’ as IF_ROW_STAT?
Answer : When there are duplicate records with same user key and different conflict_id in the base table.

When do we get ‘PARTIALLY_IMPORTED’ as IF_ROW_STAT?
Answer : When EIM is able to populate target base table and fails to populate any of the non-target base table.

Check for IF_ROW_STAT_NUM and search in the log file to find out partially imported table. Else check Temporary columns to get partially imported table name.EIM uses temporary column internally to facilitate EIM process. We do not populate T_COL.

What are different delete parameters we need to use in DELETE EIM process?
Answer : ‘DELETE EXACT’, ‘DELETE MATCHES’ and ‘DELETE ALL RECORDS’.

DELETE EXACT use user keys to delete records. EIM table needs to be populated first.

What column is to be populated while performing MERGE operation? This is used to identify the record to be merged.
Answer : IF_ROW_MERGE_ID is to be populated MERGE operation to identify the record to be merged.

T_MERGE_ROW_ID stores the ROW_ID of the surviving record. T_DELETE_ROW_ID stores ROW_ID of deleted records.
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