Informatica Interview Question and Answers

41. What is fact table?
 
    The centralized table in a star schema is called as fact table. Fact tables are three types
  • additive
  • non-additive
  • semi additive
 
Your Name Your Email-ID
Your Answer
42. What transformations are used for variable port?
 
  • Expression Transformation
  • Aggregated transformation
  • Rank Transformation
 
Your Name Your Email-ID
Your Answer
43. What is Data Transformation Manager(DTM)?
  After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run.
 
Your Name Your Email-ID
Your Answer
44. How can you define a transformation?
  A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.
 
Your Name Your Email-ID
Your Answer
45. What are Lookup transformation?
  Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup definition can be imported either from source or from target tables.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 9 of 20