Multiple choice technology programming languages

Which of the following is/are an Active transformation

  1. Sorter

  2. Connected Lookup

  3. Expression

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

In Informatica, an Active transformation changes the number of rows passing through it. The Sorter transformation is active because it can change the row order and, based on configuration, can filter rows (like using 'distinct' sort which removes duplicates). Lookup (both connected and unconnected) and Expression are passive transformations as they maintain the same number of rows.

Keep practicing — related questions