Informatica Interview Question and Answers

49. What is a transformation?
  It is a repostitory object that generates,modifies or passes data.
 
Your Name Your Email-ID
Your Answer
50. What are the types of metadata that stores in repository?
  Following are the types of metadata that stores in the repository
  • Database connections
  • Global objects
  • Mappings
  • Mapplets
  • Multidimensional metadata
  • Reusable transformations
  • Sessions and batches
  • Source definitions
  • Target defintions
  • Transformations
 
Your Name Your Email-ID
Your Answer
51. What is the differences between connected and unconnected lookup?
  Connected lookup
  • Receives input values diectly from the pipe line.
  • You can use a dynamic or static cache.
  • Cache includes all lookup columns used in the mapping.
  • Support user defined default values.
Unconnected lookup
  • Receives input values from the result of a lkp expression in a another transformation.
  • You can use a static cache.
  • Cache includes all lookup out put ports in the lookup condition and the lookup/return port.
  • Does not support user defiend default values.
 
Your Name Your Email-ID
Your Answer
52. What is the functionality of Repository manager?
  Repository manager is used to navigate through multiple folders and perform the basic repository tasks.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 13 of 15