Multiple choice technology

Sorter is an active transformation

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Sorter transformation in Informatica is classified as an active transformation because it can change the number of rows that pass through it. When configured to use the 'Sort distinct rows' option, it removes duplicate rows, thereby reducing the row count. Active transformations are those that can change the data row count or transaction boundaries, unlike passive transformations which pass all rows through unchanged.