Multiple choice technology databases

Select the efficient transformation which you can use for the same source data with different condition?

  1. Filter

  2. Router

  3. Sorter

  4. All of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Router transformation is more efficient than Filter when you need to route the same source data based on different conditions because it can handle multiple conditions in a single transformation. You would need multiple Filter transformations to achieve the same result. Router allows you to divide data into multiple groups based on different filter conditions all at once.