Multiple choice technology databases

To maximize session performance by filter it should be?

  1. Near to source

  2. Near to target

  3. Can be placed anywhere

  4. Session performance is not affected
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Placing filters near the source improves performance by eliminating unwanted rows early in the data flow. This reduces the amount of data processed through subsequent transformations, minimizing memory usage and processing time.

AI explanation

In Informatica PowerCenter, a Filter transformation should be placed as close to the source as possible in a mapping. This drops unwanted rows early, so fewer rows flow through subsequent transformations (joins, lookups, aggregators), reducing memory/CPU usage and speeding up the session. Placing it near the target instead means all the filtered-out data still gets processed through the whole pipeline first, wasting work. This is a standard Informatica performance-tuning best practice, making 'Near to source' correct.

Keep practicing — related questions