Informatica developer interview questions

Informatica developer interview questions

Q. What is meant by active and passive transformation?

A. Transformations can be or passive. An transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition. A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation

Active transformations

• Advanced External Procedure
• Aggregator
• Application Source Qualifier
• Filter
• Joiner
• Normalizer
• Rank
• Router
• Update Strategy

Passive transformation

• Expression
• External Procedure
• Maplet- Input
• Lookup
• Sequence generator
• XML Source Qualifier
• Maplet – Output