EIM Interview Questions -Part 2

We have collected the Siebel real time interview questions related to EIM ( enterprise integration manager) , these are asked in real interviews in most of the companies. All the best for your job interview!

1.How do I import international phone numbers using EIM?

Ans:

To import international phone numbers, the phone number must be prefixed with a plus (+) sign and the country code. For example, an international phone number with a country code of 44 should have the following format: +44123456789. Any phone number without a preceding plus sign in the database will be treated as an U.S.A phone Number. This will lead to the display of +1 in front of the phone number, and the use of the corresponding PHONE_FORMAT if the regional settings of the client are different.

2.How do I import URL links into the S_LIT base table?

Ans:

To import records as URL links into the S_LIT base table, the FILE_NAME column must not be null and the FILE_EXT column must be null for URLs.

3.When data is exported using an interface table (such as contacts), why doesn’t data from related child tables (such as opportunities) get exported?

Ans:

For all columns to export using an interface table (both data from the base table and data from related child tables), you need to add or modify the following line in the .ifb configuration file:
Export all Columns = TRUE
NOTE: Rows from child tables of related child tables will not be exported.

4.What is the behavior of the EIM delete process?

Ans:

The delete process performed by EIM is cascade delete. The data deleted is not restricted to the base tables mapped to the interface table that you specified in the delete process, but all child records as well. You should be very careful and specific when specifying delete criteria.
For example, using the criteria "DELETE MATCHES = EIM_PARTY, (CREATED > xxxxx)" will cause all records of S_PARTY that matches this criteria to be deleted from the database.

5.Is it possible to delete or merge rows that have the same primary user key and different conflict IDs using EIM?

Ans:

This is not possible. EIM relies on user keys to identify rows in base tables. If there are two rows in the base table that have the same user key but different conflict IDs, EIM cannot distinguish these rows. In such case, the IF_ROW_STAT field of the row in the interface table will be marked as AMBIGUOUS.

NOTE: When you are deleting records based on user keys, the parameter DELETE EXACT should be specified in the .ifb configuration file.

6. Can I remove unnecessary seed data by deleting all rows from the S_LST_OF_VAL base table?

Ans:

No, you should not remove unnecessary seed data by deleting all rows from the S_LST_OF_VAL base table. If you do so, you will not be able to reimport “clean” data and you will be forced to rebuild the seed data or restore from backup.

Use Search box to find more Siebel EIM Interview questions and Answers.