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.
 
Ravi Ranjan ,says Feb 10,2018
Aggregator is active transformation. Aggregator transformation is use grop by basis. it is use muli function of Oracle such As SUM, AVG, First_Name, Last_Name while Expression transformation is passive transformation Expression tranformation use row by row Expression transformation is use single function of Oracle. E.x. Full Name Concate- IIF(First_Name || ' '|| Last_Name).
Your Name Your Email-ID
Your Answer
77. What is the default source option for update strategy transformation?
  Data driven.
 
Ravi,says Feb 11,2018
Update strategy transformation having All Properties in Data driven Data driven e.g insert Delete update Reject.
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.
 
Ravi ,says Feb 07,2018
Sequential batch having one Session Like as per expression transformation using this as one row V_count = V_count_1 second row O_count = V_count First row we will excution my session , we got Output 0 + 1 =1 1 + 1 =2 So Second row will get out as 1,2.
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.
 
Ravi ,says Feb 07,2018
Update strategy transformation is Active Transformation. in any Scenrio we got not value data , i explain briefly such as If One Record Delhi is Present in Database While we updated Delhi in Londan,Puna Etc So we go for updated strategy transformation so updated strategy having following properties 1 insert 2 Update 3 Delete 4 Reject.
Your Name Your Email-ID
Your Answer