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 will query Opportunity [...]

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?
Will those be used in fact tables? If not then what is the purpose in using it?

Answer: