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

Passive transformations do not change the number of rows in the data flow. Expression transformation is passive because it only modifies values within existing rows. Aggregator is active (reduces rows), Joiner is active (can change row count based on joins), and Filter is active (removes rows).

Keep practicing — related questions