Informatica Interview Question and Answers

46. What are Source Qualifier transformation?
  Source Qualifier transformation is an Active and Connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier transformation. The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc.
 
Your Name Your Email-ID
Your Answer
47. What is difference between maplet and reusable transformation?
  Maplet consists of set of transformations that is reusable.
A reusable transformation is a single transformation that can be reusable.
 
Your Name Your Email-ID
Your Answer
48. What are Update Strategy transformation?
  Update strategy transformation is an active and connected transformation. It is used to update data in target table, either to maintain history of data or recent changes. You can specify how to treat source rows in table, insert, update, delete or data driven.
 
Your Name Your Email-ID
Your Answer
49. How many types of dimensions are available in informatica?
 
    There are three types of dimensions.
  • Star schema
  • Snowflake schema
  • Glaxy schema
 
Your Name Your Email-ID
Your Answer
50. What is difference between maplet and reusable transformation?
  Maplet : one or more transformations.
set of transformations that are reusable.
Reusable transformation: only one transformation.
Single transformation which is reusable.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 10 of 20