Multiple choice technology databases

Which of the following transformation is passive and connected?

  1. Aggregator

  2. Expression

  3. Joiner

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

Expression transformation is both passive (does not change the number of rows) and connected (part of the data flow pipeline). Aggregator is active (can reduce rows), Joiner is active (changes row count), and Filter is active (filters rows). Passive transformations maintain the same number of rows passing through them.

Keep practicing — related questions