Making Siebel Interviews easy

Category Archives: Informatica

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: