Informatica Interview Question and Answers

31. Name four output files that informations server creates during session running?
 
  • Session Log
  • Workflow Log
  • Errors Log
  • Badfile
 
Your Name Your Email-ID
Your Answer
32. What is the difference between lookup cache and lookup index?
  Look up Cache contains Index cache and data cache.
Index cache : Contains columns used in condition.
 
Your Name Your Email-ID
Your Answer
33. What are the difference between static cache and dynamic cache?
  Dynamic cache decreases the performance in comparision to static cache.
Static cache do not see such things just insert data as many times as it is coming
 
Your Name Your Email-ID
Your Answer
34. Define maping and sessions?
  Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation.
Session : It is a set of instructions that describe how and when to move data from source to targets.
 
Your Name Your Email-ID
Your Answer
35. What is a command that used to run a batch?
  pmcmd is used to start a batch.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 7 of 20