Informatica Interview Question and Answers

81. What is power center repository?
  The Power center repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, You can create a single global repository to store metadata used across an enterprise, and a number of local repositories to share the global metadata as needed.
 
Your Name Your Email-ID
Your Answer
82. What are designer objects?
 
  • Source
  • Target
  • Transformation
  • Mapping
  • Mapplet
 
Your Name Your Email-ID
Your Answer
83. Can you generate reports in Informatcia?
  By using Metadata reporter we can generate reports in informatica.
 
Your Name Your Email-ID
Your Answer
84. What is a reusable transformation?
  Reusable transformation: Developed in transformation developer. It can be invoked from more than one mapping or mapplet.
 
Your Name Your Email-ID
Your Answer
85. What are different Types of facts?
 
    There are three types of facts :
  • Additive : Additive facts are facts that can be summed up through all of the dimensions in the fact table.
  • Semi–Additive : Semi–additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.
  • Non–Additive: Non–additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
 
Your Name Your Email-ID
Your Answer