Informatica Interview Question and Answers

91. What are different types of transformations available in Informatica?
 
    There are various types of transformations available in Informatica :
  • Aggregator
  • Application Source Qualifier
  • Custom
  • Expression
  • External Procedure
  • Filter
  • Input
  • Joiner
  • Lookup
  • Normalizer
  • Output
  • Rank
  • Router
  • Sequence Generator
  • Sorter
  • Source Qualifier
  • Stored Procedure
  • Transaction Control
  • Union
  • Update Strategy
  • XML Generator
  • XML Parser
  • XML Source Qualifier
 
Your Name Your Email-ID
Your Answer
92. How can you improve session performance in aggregator transformation?
  Use sorted input.
 
Your Name Your Email-ID
Your Answer
93. Why we use stored procedure transformation?
  A stored procedure transformation is an important tool for populating and maintaing databases.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 20 of 20