Multiple choice technology databases

which transformation filters based on more than one condition?

  1. Filter

  2. Router

  3. Lookup

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

Router transformation can filter based on multiple conditions simultaneously. You define multiple groups with different filter conditions, and Router routes each row to matching groups based on those conditions. This allows you to send rows to different downstream paths based on multiple criteria. Filter transformation only handles one filter condition per transformation instance. Lookup retrieves reference data, and 'All' is incorrect.

Keep practicing — related questions