Informatica Interview Question and Answers

53. What are the active and passive transforamtions?
  An active transforamtion can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.
 
Your Name Your Email-ID
Your Answer
54. What is the filename which you need to configure in UNIX while installing infromatica?
  pmserver.cfg
 
Your Name Your Email-ID
Your Answer
55. What databases need to be registered as system ODBC data sources for the Data Warehouse Center?
  The Data Warehouse Center database that needs to be registered as system ODBC data sources are:
  • Source
  • Target
  • Control databases
 
Your Name Your Email-ID
Your Answer
56. What are the techniques for handling SCD’s?
 
  • Overwriting
  • Creating another dimension record
  • Creating a current value filed
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 14 of 15