Multiple choice technology

To increase performance of a mapping where shall one place Filter in a mapping?

  1. Near to the target

  2. Near to the source

  3. In the middle of the mapping

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

Placing filters near the source reduces data volume early in the pipeline, minimizing unnecessary processing and memory usage in downstream transformations. Filtering downstream means carrying irrelevant rows through multiple transformations, which significantly degrades mapping performance.

Keep practicing — related questions