Real Time 70 top Siebel CRM Interview Questions and answers for freshers and experienced job interview questions pdf
Siebel CRM Interview Questions and Answers List
1. What is SIEBEL?
SIEBEL is the leading provider of Customer Relationship Management (CRM) software
2. What difference between Fields and single value fields?
multivalue field has the child values from a chind BC for the parent record configured through MVL. single value field will be either from the base table or joined table.
the Difference between Single Value Field (SVF) and Multi Value Field(MVF)
SVF- a field in BC which references a column in a table
MVF- a field in parent BC which references a field in child BC
Field-Identifies and defines a field in a business component. All fields making up a business component record contain entries from both Single Value Field and Multi Value Field object types.
3. What is the difference between 1:1 and 1:M extension tables?
1:1 extension table is like an extension to the base table. if we do not have the required table space in the base table for craeting new extension columns, we will use the 1:1 extension table’s columns using an implicit join.
in contrast, 1:M extension tables are used for parent child relationship with the base table. where the 1:M extension has only related to the base table. for example, for a contact (S_CONTACT) there will be a number of specialities in the extension table(S_CONTACT_XM) with the parent child relationship.
4. What is complex join? Difference with Foreign key Primary Key join?
Complex joins are joins which have following diffrences from a PK-FK joins
# Complex joins can have conditional mappings like >,<,>=,NOT,AND,etc apart from ‘=’ whereas the PK-FK joins are always ‘=’.
# PK-FK joins are always (1-N), whereas complex joins can have (1 – 0,1) and (0,1 – N) kind of relationships
5. What is Localisation?
Modify the object definitions in the local repository.
6. What is different between bounded and unbounded picklist?
We can enter free text incase of Unbounded Picklist. But, incase of Bounded Picklist, we can not enter freetext.
7. Dynamic Picklist is used to Update Join Fields? How?
Actuavally we cannot modify the join fields we cannot do any modifications and updations on that fields to do these things we create the dynamic picklist or pickapplet.dynamic picklist to modify (to enter new records )in the join fields
8. What is the primary difference between Siebel 7.5.2 and 7.7 Versions?
are having lot of differences between siebel 7.7 and 7.5.2. the primary difference among them is ” Symbolic strings are available in Siebel 7.7 and not available in 7.5.2″. hence the future scope for upgradation like things are high in siebel 7.7.
9. Optimization techniques in EIM?
1) Limit base tables and columns to be processed by using : only base Tables,ignore base Tables,only base Columns,ignore base Columns.
2) Always delete batches from EIM tables upon completion. Leaving old batches in the EIM table wastes space and can adversely affect performance. For other suggestions on working with batches.
3) Run independent EIM jobs in parallel. Two or more EIM processes can be started simultaneously by using the Siebel Server Manager.
4) Trace Flag Settings, using Synonyms, primary key only Parameters
Limiting the Number of Records and Rows for Merge Processes.
like this many techniques are there which will optimize the EIM process
How can a particular user among four users with same responsblity can have access to particular view and this view should not be visible to other users?
The new views which are to be restricted from the other 3 users can be grouped up in a seperate responsibility and then the 1st user can be assigned that the newly created responsibility. This will save time and will ensure smooth operations as well.
10. How to create Drilldown in Form applet?
Usually Drilldowns will be in List Applets only. But, in Siebel 6 there are Drilldowns on Form applets also. But, these are not similar to those in List Applets. in order to go to the target view we need to right click on the applet, on the menu shown we can find the available Drilldowns with Title as “Go To XYZ View”.
What is the difference between MVG and Dynamic PickList?
A1: A new value could be added through an MVG where as Dynamic Pick Applet could only be used to pick a value from a pick applet which could be constrained to show relevant data. A value entered through an MVG will show up in a Dynamic Pick Applet if the Dynamic Pick Applet is based on that MVG.
11. What is detailed category in configuration, and its use?
In an application, we see a page tab let say Account. Below that we have let say My/My Teams/All Accounts. Each has a form applet showing account name, address etc. Related to this we have several tabs like account address, account profile…clicking on which show us accounts detail in that specific area.
So the Account is Aggregate category. My /my teams/all is Aggregate View…These tabs which will show details of Account is Detail Category. So any child object of an aggregate category showing details of an entity is Aggregate category.
12. How will you do validations in escripts and in configuration?
In Tools select the object definition, right click and select validate.
this is used to check the correctness of values of a particular object before going to store.
in escripting, once we write script then we can do validation by check syntax option.
13. Siebel 7.7 How do you add Button Icon in an Applet? Like New,Query,Delete.I want Activate Button also .
You can add those buttons by creating controls under that applet and specifying a method name under that.
you can get a Dropdown box for method Name and select from that..
14. What is difference between s_opty_x and s_opty_xm tables.
s_opty is a base table for which
s_opty_x is an extension table with 1:1 relationship
s_opty_xm is an extension table with 1:M relationship.
15. What difference between join specification and join definition?
ANS “Join” object specifies the table name and “Join Specification” object specifies the Primary Key Foreign Key relationship.
16. What is force active property?
Force Active property for a field makes it accessible in scripting even if it is not in UI.
17. What is Symbolic URL in Siebel.
Symbolic URL allow you to configure Portal Agents in several ways. You use Symbolic URL Arguments for two purposes, to define data to be sent to an external host and to submit commands to SWE that affect the behavior of Portal Agents.
18. What value will get stored in the database when a field has both predefault value and post default value
Answer is Predefault Value.
Explanation: When user clicks the new record button,predefault value will get populated in that field, post default value will get stored only when user doesn’t type any value in the field and saves the record. Since already value has been populated by predefault property, it will get stored in the database
19. Difference between LOV and Picklist??
LOV is to store the values for the picklist in the application admin and where as picklist is used to select the value from the list of values
20. How to run Genbscript.exe?
The syntax for running genbscript is:
When you run genbscript.exe, all browser scripts in the repository are generated. They are placed in a directory that you specify using the destination directory parameter (dest_dir). The genbscript.exe utility is located in:
siebsrv_root/bin or client_root/bin
genbscript config_file dest_dir [language]
21. What is Detail Applet and Association Applet?
Detail applet is nothing but Form Applet, Association applet is used to implement M:M relationship.
Detail applet word is used in the context, when there is a Master Detail relation. in this case there will be one master and many child records. so, we usually show these child records in list applet and not in form applet
22. What is the difference between MVG applet And a pick Applet?
MVG is nothing but to display the child records for the parent table ,and for pick applet to update join fields
Pick applet is used when there is 1:1 relationship and MVG is used when there is 1:M r/n.
pick applet is used for M:1 relationships. basically we use pick applet to change the stamping of the foreign key in the base table by picking a different record other than existing (modifying join column).
23.what is applet toggle how many types are there?
Applet toggle identifies one or more alternate applets to use in displaying the data of a business component. They are 2 types static and dynamic
24. How to call external webpage from Siebel application
This can be done through scripting..
For an example:
In preinvoke method for a button click,
will open a webpage for a given url in URLNAME variable
25. what is the maximum number of applets can be there in a view
There can be eight applets at most.
8 is max and that also depends on the web template you are using
There can be eight applets at most in Siebel6.
There can be 16 applets at most in Siebel7.7
26.whats the difference between siebel 7.5 and 7.8? if we upgrade the application to 7.8from 7.5 what are the areas we need to give importance from QA(Testing) point of view?
Various Areas are –>
1. Workflows to be activated
2. All server components ( including repeating component)
3. All Interfaces
4. Third party software integration ( Humming Bird, ChartWork Server,
IBM-LDAP, Actuate etc)
5. Actuate reports
6. Copy/Reprice Quote Functionality
7. Assignment Manager
Siebel 7.8 is different from version 7.5 in many ways. some of them are;
1. Product Configurator. This was one of the major changes in Siebel 7.8 , now versioning of the products is supported and same product can have multiple versions available. only one version is active at a time.
27. What is the use of the indirect multivalue link and how do you configure it?
consider there are 3 bus comps. in that say there is no relation ship between the 1st and 2nd bus comp and there is relation ship between 2nd and 3 rd bus comp. but some fields are necessary from the 2nd bus comp. it will be fetched through the relationship from 1st and 3rd bus comp. this is called indirect MVL.
28. How do you display the no. of records in a picklist(combo box/drop down) not the records in the pickapplet, in just 3 rows and not 5 rows(which is the default)?
Set the HTML no of rows to 3.
29. How do you import LOV\’s
With regard to my question above, please specify how we can import data without EIM. Is it possible to do it using siebel tool/client?
Without EIM cannot importing the data it’s by the siebel tool.
we can use siebel VB scripting
You can export LOVs using Application Deployment Manager.
30. What is Seibel Admin Mode View? How to create one?
Admin Mode View is nothing but, it has Admin Mode Property set to true. It will override all the visibility rules.
31.What is Siebel Admin Mode View? How to Create this?
Admin Mode property set to TRUE in View object definition.
Admin Mode view overrides the property of Business component. This view allow the user to do update, insert, and delete etc. which may not be available in other view of same BC. Because admin mode view overrides the No update, No insert ,No delete BC property. used for administration purpose
31. What is the purpose of 1:M extended table?
1. we can use it in parent child relationship where the child entity is lonely related to the parent table.
2. or we can make it as a intersection table by adding the foreign key of
another table’s primary key in the 1:M extended table
32. What is Siebel Gateway?
Siebel Gateway is the name server which controls the Enterprise Server.
33. How can you do the data cleansing in EIM?
EIM Does not support data cleansing
34. How can you resolve Foreign Key in EIM?
Populate all User key columns which will resolve foreign key. still u have doubt let me know
35. What is the use of Item Identifier.
with regard to control properties in applet it identifies, how to move through tab button.
by this property we can arrange/change the order of the page tab/view tab
nope.. it’s an ID of control tag in the applet.. but for the tab sequence its HTML sequence Property
Note: it’s as per 7.7 version.
36. what is the use of LDAP user ?
ANS It is used as a third party authentication for an end user which can be modified to have a single sign on to multiple application apart from Siebel.
37. Where does the Primary Field of an MVG stored?
Primary Id Field will be stored in the Parent BC.
38. What is the difference between Links and Multi Value links?
Link is used for Master Detail View of two BCs. where as MVL is used to view the child records using MVG. MVL uses Link to get the records from the
I want to have some real time business scenarios for my project….can anyone provide me
39. What is foreign key table in Siebel?
foreign key table is the property for a column in the table. it specifies for a column from which table this reference has been came OR
This is one of the properties of the column in a table. It specifies the table to which this column is a foreign key
40. Why do you need Primary in MVG?
for a multivalue field there is a field called SSA Primary Field available in the parent BC. this field stores the primary child. which avoids querying on the
child BC for displaying the value in the MVG. this is for performance improvision. this creates 1:1 Link.
Multi value group applet is a dialog box which displays and maintains a set of records from another BC associated with currently displayed BC record. One
record in the MVG applet is made primary. The record with primary check box ticked is the one which gets displayed in the originating applet controls.
A Primary creates a M:1 relationship b/w the Parent and the Child record.
Thus it increases the performance by allowing a single query using the SQL join to display both the Parent and the Child records in parent Applet.
Without primaries, each MVG needs a separate query to display a child record in the parent Applet. With Primary, using a single query, you will be
able to display both the parent and the child records.
41. when do we use genbscript.exe?
Whenever we make changes to the UI level…it is advisable to run genbscript.exe
genbscript stands for generate browser script. genbscript is used to generate browser scripts from command line interface
42. If a view has Admin Mode Property =
TruthenwhatwillhappentoUserProperties we write on them
If a view has adminmode property true then The administrator see all the views———mani
The User Properties won’t work for that view.
That’s Right , I don’t think it will work practically in 7.7, I set true read only field at applet level and I tried at bc level also but , the out put
which I’m expecting is coming .
IF any body can help me out , I will be thankful
When a view has its Admin Mode Flag property set to TRUE, it overrides the Read-Only properties set at the Business Component level only, and not at the applet level
43. When do you use “CanInvoke(False/True)” method in scripting.
We use it before invoking a method in PreCanInvoke Event and verify a condition. Based on the result, we can make the method Invoke =True/False. It is
just like validating a condition before invoking the method.
To enable/disable the menu items and buttons on the applet if the required condition is met
44. When do you use Property Sets in Siebel
Property Sets are the Hierarchical structures of Variable Names and Values. These Property Sets can be used in Workflow processes Parameters or for any input or output Parameters in scripting.
Ex: var input = TheApplication().NewPropertySet();
var output = TheApplication().NewPropertySet();
after this we can store sets of Variables and their values.
45. What is Client Business Service?
We can see the Business Services Client also. These are called Client Business Services we can see them in Business Service Administration Screens.
We can write the script for the BS in the client itself. After writing the BS there is no need to compile those BS’s.
46. When do we go for Dynamic PickList and for Pick Applet?
We go for Dynamic Picklists When we want to update joins( as normally joins are not updatable). We go for a pick applet when we choose a dynamic
picklist. Pickapplets help you that the whole list applet of the Bc whose field is joined to the parent. Where as in static picklist you can only choose from
predefined values but can’t update with any other values.
47. what is eapps.cfg file. and what is its significance.
eapps.cfg file means swse.
This significance is which application should point to which object manager
eapps.cfg is the single configuration file for all siebel applications. It contains configuration information, login and security settings. It contains connect
string for each siebel application
48. is it possible to have multiple database servers for one gateway server.
YES, But it needs multiple enterprise servers, for multiple database. As not more than one database, could be added to an enterprise server, these intern
could be connected to a single Gateway Server
49. what is the function of SWSE on the Web Server? what is it?
SWSE(Siebel Web Server Extension)’s function is to accept the siebel requests and pass it on to Gateway server where the server manager decides, to
which siebel server component should this request go
50.What is the “Parent Category” property for a Screen View?
This Parent Category specifies the view heading for a bunch of views related. the views belongs to this Parent Category will be shown as View
Tabs below the master applet
50. what is horizontal and vertical in siebel?
Siebel Horizontal application is general to every industry. where as Vertical is specific to a industry. such as eAutomobile, eInsurance, eBanking etc.
These are the types of applications. Example for Horizontal applications is transport. Here are examples for vertical applications are Eservice Call center
51.Why do we use Symbolic Strings in Siebel 77
For up gradation and language conversions…..
In Siebel the text that is displayed on the screens and views are stored in the repository and compiled to an SRF file. This includes the names of every screen,
views and fields. When you display a page the server uses the SRF file to determine which fields to show and what test (strings) are associated with each
field. This model of keeping the strings from the view definition is called symbolic strings.
Reduces the redundancy
Simplifies maintenance because only you have to maintain one string for a given Term
Reduces the localization costs, Time and inconsistencies.
51. How do you specify a view to be displayed as aggregate view in Siebel 7.7
when add the View to the Screen you have a property called Type in which, you have to select “Aggregate View”.
when adding view to screen specify the type as aggregate view. But Before that you should create the parent category. Then add this parent category to
52. When you have Pre Default Value and Post Default value for a Field, which one will be stored in the Database
Please tell me how to add questions in latest Questions at home page
Pre Default Value will be defaulted when new record is created. Post
Default Value will be defaulted if there is no value specified for the field. so, Pre
Default Value will be stored in the Database. You can add questions by clicking the hyperlink on the above bar “Ask Question”.
53. What is All Mode Sort?
This property determines whether or not siebel will override the sort specification and if so determines the sort that will be applied to the BC
for All or Manager’s view. The values are TRUE, FALSE or NORMAL NORMAL-usesBCdefinedsortspecificationTrue –Overrides the BC sort and
Uses theU1index False – Removes all sorting
54. What does Business Component User Mode indicate
Business Component User Mode specifies the Visibility setting for the BC. Like “All”, “Personal”, “Manager”, “Organization
55. what is the link specification
To predefault parent bc field in any of his child bc, this property must be set to true.
Link spec uses parent type default values & gets the value for the child record
56. What is the difference between “PickList Generic” and “PickList Hierarchical” Business components?
PickList Generic” BC is used for Static Picklists. “PickList Hierarchical” is used for Hierarchical PickLists
57. What is an extension table and how is it related to base table?
Extension table may be 1:1 relation table to the base table or a 1:M relation to the base table. 1:1 extension table and the base table are logically
considered as a single table. Par_row_idwillbetheforiegnkey.
Extension tables are 1:1 or 1:M extensions of Base tables, like S_PARTY (base) has S_CONTACT etc. For a 1:1 extension there is implicit join but for a 1:M
extension. You can only extend a base table. For 1:1 there is a PAR_ROW_ID to ROW_ID join and for a 1:M there is 3 different columns that represents a unique
58. What are Pre defined Queries?
if anyone has worked on the siebel application they will understand this more easily.
assume that u have enabled call center in your siebel application and once u login to this application and then click on various link in the application, we find at the top right hand corner a list box of some statements. these statements are called pre-defined queries, which will help the customer in accessing the records faster
this reducing the interaction of the business component with the database.
Pre Defined queries are some thing which helps us to navigate directly to particular screens or views. it helps in accessing the screens or views in faster
59. How do you assign responsibilities to employees in Siebel?
In Administration Group > Employee there is a field called Responsibility there add your new Responsibility, make as Primary and remove the old one
Go To Sitemap->UserAdministration->Employees
In the Employee Applet Query for the required Employee and there in u will find a Responsibility field just click that to find the required responsibility
and add it. If required set it to primary.
Go To SiteMap->UserAdministration->Employees
In the Employee Applet Query for the required Employee and there in u will find a Responsibility field just click that to find the required responsibility
and add it. If required set it to primary
60. How do you set up employees in Siebel?
Create the users first, then assign them some responsibility and position. then create the database login
The Employee is also a USER who must be assigned with a valid position.
Since the Position maps to the Division which in turn maps to a Organization the Data visibility is maintained through this position and the Responsibility of the
61. What is the difference between an organization and division in Siebel
These are the hierarchical levels in the siebel, under organization the divisions will come
Organizations can be used to control data visibility, Divisions cannot
62. what is the difference between Join and Link?
(i)It defines M:1 relation between a field in BC to the Column in table.
(ii)Source Field is the Foreign key field in BC while Destination column is the Primary Key column in Table.
(i)It defines 1:M relation between a field in parent BC to the field in the child BC.
(ii)Source Field is the Primary Key field in Parent BC while Destination
Field is the Foreign Key field in child BC.
JOIN: gives relationship between two tables. LINK: Gives relationship between two BCs.in link child Bc is included under parent Business Object
Join is between BC and table and is used to retrieve no or atmost one record.
where Link is between two BC’s which will retrieve more than one record for a parent record
63. What is the difference between EIM and EAI?
EIM : is used for importing or deleting the large data
EAI : is used to integrate the Applications
EIM : It is batch mode Integration. When data volume is large then we have to go to EIM
EAI : It is real time Integration. When data volume is small then we have to go to EAI
EAI: is used when there are frequent changes in the database. Also when the data is small.
EIM: is used when there is large data(eg. at the time of implementation) .also when There is no need of real-time-feeds.
64. How do you import List of Values?
Depends on any Hierarchies, but using EIM_LST_OF_VAL(for EIM load) import parents first then children, otherwise you will receive failure message.
65. When do we go for BC level user properties
ANS: when we need to set or reset the properties at runtime
66. What is implied Join. Where do we find it ?
Join between two Tables. Join Object defines The Relationship Between a Bc and a table. Join allows Bc to get Column from table rather then base
In Mvg Applet we can find the join, It uses Foreign key to get the Row.
Implied joins are between Base Table and Extended Table. These are typical 1:1 joins. There is no need to create explicit join objects for them. If you
go to the Flat Tab in Object Explorer, all the joins which have the alias name same as the table name are Implied Joins.
Implied joins are also called implicit joins. Its a join existing b/w a Base table and its extension table.
67. How do you recognize that a particular table (Base table ) can be extended?
If the table property is Private, then we can not extend the table. If it is Public, we can.
68. What are the different types of Columns.
Columns: 1.Data (Public), 2.Data (Private), 3.Denormalized, 4.Extension, 5.System
69. what are different types of Tables?
Base Tables and Interface Tables
3 type of tables:
Data , Repository & EIM tables
There are 4 types of tables in siebel
1) Base Table (Ex: s_contact, s_user)
2) Extension table ( Ex: s_contact_x)
3) EIM tables
4) Intersection Tables (Ex: s_org_bu)
a. data tables
1. base tables
b. repository tables
c. interface tables
70. How many type of siebel Data model extensions are there?
standard and custom extensions
Siebel CRM Interview Questions and Answers List