Multiple choice technology

Which transformation can serve as both active and passive transformation?

  1. Source Qualifier

  2. Router

  3. Sorter

  4. Filter
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Sorter transformation can be both active and passive. It's active when used with 'Distinct' output option (changes row count by removing duplicates), and passive when used only for sorting (maintains row count). Source Qualifier, Router, and Filter are purely active transformations.

Keep practicing — related questions