Making Siebel Interviews easy

Monthly Archives: April 2009

Updating Multiple Records via Workflow

I am back with an interesting interview question that I have been asking in past few interviews that I have taken and surprisingly nobody has been able to answer it correctly. It is quite a simple question and answer is even simpler but people are just not aware of it. Question: Create a workflow that… Continue Reading

What are Sessions and Batches?

Session:  A Session is a set of instructions that tells the Informatica Server how and when to move data from Source to Target. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.

What is the primary purpose of using surrogate key?

What is the primary purpose of using surrogate key? Will those be used in fact tables? If not then what is the purpose in using it? Answer: