Informatica Interview Question and Answers

13. What are the advantages of using surrogate keys?
 
  • We can save substantial storage space with integer valued surrogate keys.
  • Eliminate administrative surprises coming from production.
  • Potentially adapt to big surprises like a merger or an acquisition.
  • Have a flexible mechanism for handling slowly changing dimensions.
 
Your Name Your Email-ID
Your Answer
14. What is Datadriven?
  The informatica server follows instructions coded into update strategy transformations with in the session mapping determine how to flag records for insert, update, delete or reject. If you do not choose data driven option setting, the Informatica server ignores all update strategy transformations in the mapping.
 
Your Name Your Email-ID
Your Answer
15. What is metadata reporter?
 
  • It is a web based application that enables you to run reports againist repository metadata.
  • With a meta data reporter,u can access information about U'r repository with out having knowledge of sql,transformation language or underlying tables in the repository.
 
Your Name Your Email-ID
Your Answer
16. 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
123456789101112


131415 Page 4 of 15