Informatica Interview Question and Answers

76. What is difference between aggregator and expression?
  Aggregator transformation used to perform aggregate calculation on group of records Where as expression used perform calculation with single record.
 
Your Name Your Email-ID
Your Answer
77. What is the default source option for update strategy transformation?
  Data driven.
 
Your Name Your Email-ID
Your Answer
78. What is the difference between sequential batch and concurrent batch?
  In sequential batch one session will end then the other will begin. Where as in the concurrent. Batch the sessions will run simultaneously depending on the CPU availability.
 
Your Name Your Email-ID
Your Answer
79. What are the types of tracing level?
 
  • Normal
  • Verbose
  • Verbose init
  • Verbose data
 
Your Name Your Email-ID
Your Answer
80. What is update strategy transformation?
  This transformation is used to maintain the history data or just most recent changes in to target table.
 
Your Name Your Email-ID
Your Answer