Interview Questions.

Q1. What Is The Difference Between Default Column And Fixed Column Parameters?

DEFAULT COLUMN specifies a default price for an EIM column and it's far used most effective while the column is null inside the EIM table whereas FIXED COLUMN specifies a hard and fast price for an EIM column and the fixed value receives loaded within the base desk overriding the value in the EIM table column.

Q2. What Is Difference Between Con_bu And Con_bi Columns Of Eim_contact Table?

EIM_CONTACT.CON_BU and EIM_CONTACT.CON_BI columns are column pairs to map corporations. These kind of columns are present in other entities as well like ACC_BU and ACC_BI (for debts), PROD_BU and PROD_BI (for products) etc.

CON_BU and CON_BI columns maps to the BU_ID column of S_CONTACT. In EIM Interface Table object (in equipment) EIM_CONTACT has a overseas key mapping wherein you may see the CON_BI column mapped.

CON_BU column desires to be populated explicitly with the agency call whereas CON_BI column value is implicitly (that is the ROW_ID of S_BU desk) picked by way of EIM based at the company call in CON_BU. Never populate the CON_BI column via yourself, EIM handles it by using itself.

Q3. What Are The Mandatory Eim Columns That Need To Be Populated In Different Eim Processes?

The obligatory columns that need to be populated in an EIM table are:

ROW_ID: Part of EIM table person key

IF_ROW_STAT: Accepts any alphanumeric cost however adjustments after EIM processing to show the reputation of the record.

IF_ROW_BATCH_NUM: Part of EIM desk person key, specifies the batch quantity to pick out the statistics for EIM processing.

IF_ROW_MERGE_ID: Required for Merge operation only, specifies the EIM ROW_ID of the record with a purpose to be merged into.

Q4. What Does Include Parameter Mean In An Ifb File?

INCLUDE is an non-compulsory parameter in the IFB document which shows a sub technique to execute. INCLUDE names a manner to be blanketed as part of this system. More than one method can be blanketed in every other system. All protected strategies execute before the technique itself. This parameter can be used handiest in shell techniques. A shell process makes use of the INCLUDE announcement to invoke a chain of processes in a single run.

Q5. Why Does Eim Uses Temporary Columns? Give An Example?

EIM uses brief columns to control facts at some point of processing. For example, EIM may keep the ROW_ID value for a Siebel base table in a transient column. These column names start with T_ and indicate the desk or column for which they may be used. Because EIM uses those columns internally during processing, these columns in EIM tables should no longer be manipulated.

Q6. Why Using Synonyms = False Parameter Is Highly Recommended For Eim Performance Tuning?

USING SYNONYMS = FALSE saves processing time due to the fact queries that appearance up synonyms (as in case of Accounts) are not used.

Q7. What Are (primaries) Primary Foreign Keys? What Is The Use Of Primaries (primary Foreign Keys) In Siebel Data Model?

The Siebel Data Model uses primary foreign keys (or primaries) to point from a discern base desk to a child base desk. Primaries permit business common sense within the Siebel Data Model, such as figuring out the primary function for an account. Moreover, primaries improve performance by way of eliminating repeating sub queries when facts from both the figure table and the primary infant desk are displayed. If you do now not use primaries, then you definitely should execute a new question to pick out any child records whenever a figure document is displayed.

Q8. What Is Ifb File?

IFB document is a configuration record that the EIM engine reads to become aware of information like what type od process want to be performed, the batch numbers to discover the facts and other parameters. Its an ASCII text report with .Ifb extension. Before one runs the EIM task, this IFB report's parameters needs to be configured in keeping with ones requirements.

Q9. How Will You Identify The Corresponding Eim Column For A Particular Base Table Column? Say For S_prod_int.Name, Explains?

Follow the below steps:

Identify the corresponding EIM desk for the base table S_PROD_INT from siebel tools (say its EIM_PROD_INT), see question no.1@

Query for the EIM desk EIM_PROD_INT in Siebel gear in EIM Interface Table item.

Expand the EIM Interface Table object and below EIM Table Mapping child object question the bottom desk S_PROD_INT.

Expand the EIM Table Mapping object and navigate to Attribute Mapping infant item.

Query the base desk column name NAME in Base Table Attribute Column assets and you can see the corresponding column call inside the Interface Table statistics column assets.

Q10. What Is The Purpose Of Session Sql Parameter In The Ifb File?

This parameter specifies a user-described SQL announcement to be sent to the database server earlier than other SQL statements for this technique. This string is sent directly to the database and need to be a unmarried SQL assertion appropriate for immediate processing. This parameter may be used to set tracing for overall performance evaluation. Only one SESSION SQL parameter can be utilized in every method phase. This parameter cannot be used to insert or update records in Siebel base tables. EIM sends the SQL statement immediately to the database and may cause data loss for Siebel Remote and Siebel Replication Manager.

Q11. Where Does The Ifb File Reside On Server?

The IFB report is living within the siebsrv/ADMIN folder on the server. E.G. D:sba81siebsrvADMINDefault.Ifb

Q12. How Can You Identify Which Siebel Base Tables Can Be Populated By An Eim Table In Siebel Tools?

Follow the underneath steps:

Open Siebel gear

Go to Types tab and choose EIM Interface Table from the object explorer.

Query for EIM desk in Name property

Expand the object and navigate to EIM Table Mapping

This will list all of the base tables that may be populated via the EIM table.

Additionally there is a target desk for every EIM table which you may see beneath EIM Interface Table item --> Target Table assets.

Q13. What Will Happen After Processing If There Were Two Duplicate Records In The Eim Table?

EIM techniques a document once for each batch, so for each report, MIN(ROW_ID) is processed, and the opposite record is marked as a replica i.E. IF_ROW_STAT is about to DUP_RECORD_IN_EIM_TBL for the replica report. If you input the user key of a document with distinct attributes twice within the EIM table, simplest the report with the MIN(ROW_ID) could be imported or updated. The replica can be left out.

Q14. What Is Siebel Eim?

Siebel Enterprise Integration Manager (EIM) is a server component in the Siebel EAI aspect institution that transfers facts among the Siebel database and different corporate facts assets.

Q15. What Do You Mean By Non-target Base Tables?

Every EIM desk has one or more base desk mappings which can be viewed in Siebel tools. Out of those base tables one will be the goal base table which acts as primary base table for that EIM table. Rest of the base tables are referred to as as non-goal base tables. One can view the target base tables beneath EIM Interface Table object --> Target Table assets.

Q16. Why Does Oracle Does Not Recommend Using Native Sql To Perform Different Operations On Base Tables?

A very not unusual solution which people provide to this "easy" question is that "Siebel doesn't permit inserts and updates, deletes and so forth immediately into Siebel database." or a few may also say that is what Siebel has recommended and so forth.

Though direct inserts and updates inside the Siebel tables is exceedingly not encouraged, we will nevertheless do this if we're able to pick out the direct tables and associated tables in which information is to be inserted or updated.

The primary cause why we shouldn't be doing operation on Siebel tables directly is for following reasons:

Table relationships in Siebel are highly complicated. One table can be related to too many different tables, the foreign keys and the primaries are difficult to solve if we perform the operations manually like thru easy SQL statements.

Many groups use cellular customers for Siebel application. These mobile customers must be synchronized after every facts loads in order that the information is up to date for cellular customers as well. Improper synchronization will motive facts integrity problem among Siebel server database and cell user neighborhood database.

While updating information directly in Siebel tables, device columns which include LAST_UPD, LAST_UPD_BY etc are not up to date. This might also deceive the real file statistics and integrity will be misplaced. These updated facts might not be synchronized properly in other parallel jogging servers as properly like record DB server, Siebel Analytics and many others.

Hence, Siebel has endorsed that the in-built EIM technique be used for any sort of statistics operations in the Siebel tables.

Q17. What Are The Different Eim Functions?

The one-of-a-kind EIM capabilities are:

Import (Inserts and Updates)

Export

Delete

Merge

Q18. Can You Enumerate The eleven Steps For Eim Import Process?

EIM initializes any temporary columns.

EIM applies any DEFAULT_COLUMN and FIXED_COLUMN values described for the import procedure.

EIM applies any clear out queries defined for the import method.

EIM generates foreign key references for rows with corresponding present rows in the Siebel base tables.

EIM writes the appropriate ROW_ID values within the EIM table rows’ brief columns, for rows with corresponding base desk rows.

EIM creates a ROW_ID with a completely unique fee inside the base desk for each EIM desk row with out a corresponding row within the base tables.

EIM removes rows with invalid values for user keys from similarly processing.

EIM updates contents of existing base table rows with contents from corresponding EIM desk rows that have effectively surpassed all in advance steps.

EIM inserts any new EIM desk rows which have effectively handed all earlier steps within the Siebel database tables.

EIM updates primary toddler relationships in the Siebel database tables as important.

Finally, EIM runs non-obligatory miscellaneous SQL statements.

Q19. What Is The Difference Between If_row_stat And If_row_stat_num Columns?

IF_ROW_STAT column inside the EIM desk consists of the reputation of each statistics after processing like IMPORTED, DELETED, NOT_ALLOWED, MERGED etc. Whereas IF_ROW_STAT_NUM column consists of a 0 (0) if the row turned into correctly processed to of entirety or the pass quantity in which the failure happened.

Q20. How Can You Manually Create Eim Column For An Existing Base Table Column?

You can not manually create a EIM column for an existing base desk column. The answer is to run the EIM mapping wizard as a way to map all of the new extended columns and the vintage columns which have no EIM column mappings currently.

Q21. In The Ifb File, You Have Mentioned The Credentials For Database Incorrectly But The Proper Credentials Are Stored At Srvmgr Level, Will The Job Throw Any Error?

Credentials noted in IFB report are overridden by using the credentials saved at srvmgr stage, so in this case it'd now not throw mistakes.

Q22. How Do You Run Eim Table Mapping Wizard In Siebel Tools?

Let’s take an instance: Suppose a brand new column is extended in S_CONTACT and you want the corresponding EIM column to be generated.

Follow the beneath steps for jogging EIM mapping wizard:

Open Siebel gear

Go to Table item and question for "S_CONTACT or EIM_CONTACT".

Lock the projects of both the tables. (By Menu Bar --> Tools --> Lock Project)

Right click on on S_CONTACT document and pick out EIM Table Mapping. EIM mapping wizard will open.

Select the EIM table from list of EIM tables. (In our case its EIM_CONTACT)

Click subsequent and then Finish.

After a success final touch of the wizard, Click on Apply/DLL button for EIM_CONTACT file and supply the info and click OK.

Finally prompt the EIM_CONTACT desk by way of clicking the Activate Button.

Q23. How Can You Identify Which Eim Tables Can Populate A Siebel Base Table In Siebel Tools?

Follow the underneath steps:

Open Siebel tools

Go to Flat tab and choose EIM Table Mapping from the item explorer.

Query for the bottom table in Name assets

Navigate to the Parent Interface desk call property to see all of the EIM tables that can be used to populate the bottom desk.

Q24. Explicit Primary Mapping Does Not Occur In Each Eim Table Mapping. In Which Case Can You Find The Explicit Primary Mapping Defined In The Eim Table Mapping?

If both the figure desk and the primary child table of a primary foreign key are mapped to the same EIM table, then once will see an specific primary mapping for this number one overseas key below the table mapping of the primary infant desk.