Siebel Interview question

March 26, 2007 at 11:57 pm 5 comments

I’ve interviewed a bunch of Siebel techies and have evolved a few favourite questions, all based around the same theme: attempting to uncover technical breadth while avoiding obscure ‘gotcha’ questions. Things like this:

Q: How would you update a second field every time a first field is changed?

This is a great question: simple enough that a junior dev straight out of a tools course should come up with a few options and have some idea how they weigh up, but broad enough that a senior techie can lead you into detailed discussions about performance vs maintainability, good practices, upgrade issues, etc etc.

If the candidate’s running out of steam, leading questions can coax them toward more inventive answers. For instance:

  • What if the second field is in a different business component?
  • What if there are multiple fields to be updated?
  • What if the second update needs confirmation?
  • What if the update still has to happen for batch (EAI/EIM) updates?

To the answer: I reckon the following is not a bad list to cover-off, but there’s still a few missing…

User Properties
+ minimal config
+ real time
+ robust (mostly!)
– limited
– require srf update

Runtime Events to Workflow Process
+ most things possible with native, compiled Siebel Operations
+ declarative, flexible, upgradable without srf update
+ long-running workflows for multiple consecutive events
+ real-time, optional asynchronous
– no loops (almost) without custom business services
– overhead of instantiating the workflow first time (then cached), which can have a big impact on mobile users

Server scripts
+ simple to write
+ low overhead
– not declarative, requires srf release
– higher level than vanilla C++ services (so slower, in theory)
– limited possibility to interact with the user

Browser scripts
+ opportunity for full manipulation of DOM, real-time interactivity
– maintenance headache (generating script, keeping versions current)
– interpreted at run-time (so slower, in theory)
– limited speed, memory space etc

Workflow Policy to Workflow Process
+ fully robust database-level trigger
+ fully asynchronous
– not real time, interactive
– not declarative, requires DBA maintenance

Advertisements

Entry filed under: Configuration, Interview Question, Siebel.

Locally unlocking a locked Project Changing the Local Database Password

5 Comments

  • 1. Siva  |  February 4, 2008 at 9:42 pm

    Hi
    I am having a requirement as below.
    There is a list applet with a list column “Amount”.I made the total of the “amount” in all rows displayed in footer using “total required propery” in applet.
    Actually the field “amount” is the calculated field in a BC
    I need to extract the total that is displayed in footer for the “amount” field to a control in form applet which using some other BC.This form applet located just below the list applet where list column “amount” is present.

    Can we do this without scripting? if yes please explain me how to do?
    else..please help me to write scripting for this.
    Thanks in advance.
    Regards,
    siva __.____.

  • 2. Siva  |  February 4, 2008 at 9:43 pm

    Hi Friends
    > I ahve one requirement.we have one date field.But we need to display in
    > three fields that date,we need to split the date and have to show
    > like month in one field, and year in one field, day in one field.throufgconfiguration.
    > for ex: we have 1/23/2008
    > we need to show in month field 1
    > we need to show in day field 23
    > we need to show in year fiedl 2008
    >
    > it is very urgent req, please reply asap
    >
    > thanks
    > Siva__.____._

  • 3. stuandgravy  |  February 4, 2008 at 9:51 pm

    Question 1: how to calculate a total on a form applet?

    You need to set up an MVG and use an aggregate function. See here.

  • 4. stuandgravy  |  February 4, 2008 at 9:58 pm

    Question 2: how to split dates?

    If I assume you just want to display the date split out, not capture it that way, then you can use three calculated fields formatting the original date field with the ‘ToChar’ function. The function’s in Bookshelf, but as an example ToChar([Date Field], “dd”) would hold the day portion of the date.

  • 5. Siva  |  February 4, 2008 at 11:56 pm

    Hi i will be happy for that………. could U ple give me how we can Write ple give detail…………………ple help me


Feeds


%d bloggers like this: