Multiple choice technology

which transformation can act as Active as well as passive based upon the property we set ?

  1. Sorter

  2. Router

  3. Filter

  4. Aggregator
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Informatica PowerCenter, the Sorter transformation can be configured as either Active or Passive. By default, it's Active (changes row count), but setting properties like 'distinct' can make it Passive. Router, Filter, and Aggregator are always Active transformations.

Keep practicing — related questions