Multiple choice technology packaged enterprise solutions

Which transformation is used for filtering rows based on condition and it also passes rows that do not satisfy filter condition

  1. Router

  2. Filter

  3. Sorter

  4. Splitter
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In OWB, the Splitter transformation routes rows to different targets based on defined conditions, including a default group for unmatched rows. In contrast, the standard Filter transformation discards non-matching rows entirely, Sorter only reorders rows, and Router is the Informatica equivalent rather than the OWB Splitter.

Keep practicing — related questions