Multiple choice technology platforms and products

Is sorter an active or passive transformation ?

  1. ACTIVE

  2. PASSIVE

  3. Either ACTIVE or PASSIVE

  4. Neither ACTIVE Nor PASSIVE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Sorter transformation in Informatica is an ACTIVE transformation because it can change the number of rows passing through it (though it doesn't typically eliminate rows, active transformations are those that can potentially change the data row count or transaction boundary). Passive transformations like Expression don't modify the row count.

Keep practicing — related questions