Informatica Interview Question and Answers

16. What is Session and Batches?
  Session: A session is a set of commands that describes the server to move data to the target.
Batch: A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc).
 
Your Name Your Email-ID
Your Answer
17. What are slowly changing dimensions?
 
    Dimensions that change overtime are called Slowly Changing Dimensions(SCD).
  • Slowly Changing Dimension-Type1 : Which has only current records.
  • Slowly Changing Dimension-Type2 : Which has current records + historical records.
  • Slowly Changing Dimension-Type3 : Which has current records + one previous records.
 
Your Name Your Email-ID
Your Answer
18. What are 2 modes of data movement in Informatica Server?
  There are two modes of data movement are:
Normal Mode in which for every record a separate DML stmt will be prepared and executed.
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.
 
Your Name Your Email-ID
Your Answer
19. What is the difference between Active and Passive transformation?
  Active Transformation:An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.
Passive Transformation:A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.
 
Your Name Your Email-ID
Your Answer
20. What is the difference between connected and unconnected transformation?
  Connected Transformation:Connected transformation is connected to other transformations or directly to target table in the mapping.
UnConnected Transformation:An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 4 of 20