Siebel Enterprise Integration Manager Interview Questions Answers, Siebel EIM Interview Questions Answers.
Why we need user key column mapping?
Answer : 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?
Answer : The relationship is cited below.
- 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 tables?
- 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?
Answer : 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?
Answer : 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?
Answer : 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?
Answer : 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?
Answer :
- 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?
Answer : There are Two Types:
A) Header Section and B) Process Section
What is .ifb? Mention its use?
Answer : 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 important parameters.
What is called an interface table and why we use interface table in EIM?
Answer : Interface table is a staging area for EIM process. Data from legacy is transferred to EIM table first using non-siebel process. For this, we need interface table in Siebel.
How do you import List of Values?
Answer : It 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?
Answer : You need to do the following as below. This article discusses in detail about Siebel EIM Data Mapping
Answer : The status of EIM Process could be seen in IF_ROW_STAT column in EIM Interface table.
Name the Mandatory Columns for EIM Processing ?
Answer : The mandatory columns in EIM processing are listed below.
ROW_ID
IF_ROW_BATCH_NUM
IF_ROW_MERGE_ID
IF_ROW_STAT
IF_ROW_STAT_NUM
Will modifications to a BC affect an EIM import process?
Answer : The answer is No, Enterprise Integration Manager (EIM) always works at the table level.
Data in the EIM table columns are imported directly into the base tables. Hence, any changes to the configuration of the BC will not affect the EIM process.
Answer : There are Two Types:
A) Header Section and B) Process Section
What is .ifb? Mention its use?
Answer : 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 important parameters.
What is called an interface table and why we use interface table in EIM?
Answer : Interface table is a staging area for EIM process. Data from legacy is transferred to EIM table first using non-siebel process. For this, we need interface table in Siebel.
How do you import List of Values?
Answer : It 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?
Answer : You need to do the following as below. This article discusses in detail about Siebel EIM Data Mapping
- 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.
Answer : The status of EIM Process could be seen in IF_ROW_STAT column in EIM Interface table.
Name the Mandatory Columns for EIM Processing ?
Answer : The mandatory columns in EIM processing are listed below.
ROW_ID
IF_ROW_BATCH_NUM
IF_ROW_MERGE_ID
IF_ROW_STAT
IF_ROW_STAT_NUM
Will modifications to a BC affect an EIM import process?
Answer : The answer is No, Enterprise Integration Manager (EIM) always works at the table level.
Data in the EIM table columns are imported directly into the base tables. Hence, any changes to the configuration of the BC will not affect the EIM process.
Related Posts
No comments :