Multiple choice technology platforms and products

To maximize session performance which of the following is true for a FILTER Xformation ?

  1. Keep the Filter transformation as close as possible to the sources in the mapping

  2. Keep the Filter transformation as close as possible to the Targets in the mapping

  3. Either of the options a.) and b.)

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Placing the Filter near the source means fewer rows flow through downstream transformations, reducing memory and processing overhead significantly. The earlier you eliminate unwanted rows in the data flow pipeline, the more efficient the session runs.

Keep practicing — related questions