Informatica Interview Question and Answers

41. Which path will the cache be created?
  User specified directory. If we say c:\ all the cache files created in this directory.
 
Your Name Your Email-ID
Your Answer
42. What is dynamic lookup?
  When we use target lookup table, Informatica server dynamically insert new values or it updates if the values exist and passes to target table.
 
Your Name Your Email-ID
Your Answer
43. What is the difference between Informatica Power part and power center?
 
  • Using power center we can create global repository.
  • Power mart used to create local repository.
  • Global repository configure multiple server to balance session load.
  • Local repository configure only single server.
 
Your Name Your Email-ID
Your Answer
44. What is difference between the source qualifier filter and filter transformation?
  Source qualifier filter only used for relation source where as Filter used any kind of source.
Source qualifier filter data while reading where as filter before loading into target.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 11 of 15