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.

Full Story »

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:

Full Story »