Informatica Interview Question and Answers

36. What is Datadriven?
  The informatica server follows instructions coded into update strategy transformations with in the session maping determine how to flag records for insert, update, delete or reject.
 
Your Name Your Email-ID
Your Answer
37. What is power center repository?
  The PowerCenter repository allows you to share metadata across repositories to create a data mart domain.
 
Your Name Your Email-ID
Your Answer
38. What is parameter file?
  A parameter file is a file created by text editor such as word pad or notepad. U can define the following values in parameter file.
Maping parameters
Maping variables
session parameters.
 
Your Name Your Email-ID
Your Answer
39. What are the types of lookup caches?
 
  • Static cache
  • Dynamic cache
  • Persistent cache
  • Shared cache
  • Recache.
 
Your Name Your Email-ID
Your Answer
40. What are Stored Procedure transformation?
  Stored Procedure transformation is an Passive & Connected or UnConnected transformation. It is useful to automate time-consuming tasks and it is also used in error handling, to drop and recreate indexes and to determine the space in database, a specialized calculation.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 8 of 20