Informatica Interview Question and Answers

66. What are the benefits of DWH?
 
  • Immediate information delivery
  • Data Integration from across, even outside the organization
  • Future vision of historical trends
  • Tools for looking at data in new ways
  • Enhanced customer service.
 
Your Name Your Email-ID
Your Answer
67. Is It Possible to invoke Informatica batch or session outside Informatica UI?
  PMCMD.
 
Your Name Your Email-ID
Your Answer
68. Why we are going for surrogate keys?
 
  • Data tables in various source systems may use different keys for the same entity.
  • Keys may change or be reused in the source data systems.
  • Changes in organizational structures may move keys in the hierarchy.
 
Your Name Your Email-ID
Your Answer
69. When is more convenient to join in the database or in Informatica?
 
  • Definitely at the database level
  • at the source Qualifier query itself
  • rather than using Joiner transformation
 
Your Name Your Email-ID
Your Answer
70. How do you measure session performance?
  By checking Collect performance Data check box.
 
Your Name Your Email-ID
Your Answer