GeeKs Blogging @ dotCOM

Siebel EIM – USING SYNONYMS

Performance is always a major issue in most of the Siebel Intallations. In a project where large scale EIM Processing is needed, rest assured, Performance would be the from amongst the most discussed topics, at least from the Acceptance Testing phase, if not before!

EIM Data loads can turn out to be for millions of records, and many tens of GBs of Data being imported is a common sight (talking in terms of the Oracle Database Data File footprint). The customer has to be around that size, if he is actually going in for a Siebel CRM implementation I guess!

In such critical situations, optimizing the Performance at every step becomes equally crucial. One such parameter I came across when researching on this was the parameter, “USING SYNONYMS” that we may use in the IFB file at the time of EIM Data Load from Staging Tables (EIM_) to the Siebel Base Tables (S_). Do note that there are many other parameters too, to optimize it and improve Performance.

As per the Siebel Bookshelf, query on Account Synonyms are controlled by this parameter. Actually, Siebel stores the Account Synonyms in the S_ORG_SYN table. An extra query is run against this table (S_ORG_SYN) whenever a query is run against the Siebel Accounts Base Table (S_ASSET). Thus, when inserting records through EIM, Siebel checks for Duplicate records with each insert, and thus the extra query.

I will try to explain the concept of Synonyms using a simple example. If an Account appears in our DB as “AB/C Account”, we may want to define a synonym to it called, “ABC Account”.

An interesting fact is that I have found this Siebel feature to be available only for Siebel Accounts, and not for any other entities so far. Please drop a comment if you found something different.

Usage:
In the “Import Accounts” section in the IFB (for example), add the following line
USING SYNONYMS = FALSE

By default, this parameter is set to TRUE. If Account Synonyms are not being used in our application (which is generally the case), we can safely set this parameter to FALSE.

At times, people tend to do the mistake of using the parameter, “USE SYNONYMS” instead of this one. Please note that this throws an error.

The above discussion is partly valid for Siebel Assignment Manager as well, as that also uses the S_ORG_SYN table.

Related posts:

1. Siebel 7.x – Party Model Changes After introduction of party model, the table structure (as far...
2. EAI Siebel Adapter BS – Upsert Multiple Child Records EAI Siebel Adapter finds its usage in almost all integration...
3. Siebel – EAI Siebel Adapter – Looping Multiple Records This is a follow-up post on the post, Siebel –...
4. Siebel EIM – Custom column mapping It’s a very basic concept explaining how we can generate...
5. Siebel – Run Case Insensitive queries This is a nice tip I ran across. All the...
6. Siebel – Popup Update Only Hi all, I was working with Siebel Multi Valued Links...
7. Siebel – Looping multiple records – Query and Process In my last post, I discussed as to how we...