Multiple choice technology

For better performance Filter transformation should be ideally placed ..............?

  1. Late in the mapping

  2. Early in the mapping

  3. Before Router Transformation

  4. Before Aggregator Transformation
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Filter transformations should be placed early in mappings to reduce the data volume flowing through subsequent transformations. This improves performance by minimizing unnecessary processing on rows that would be filtered out anyway. Placing filters late means processing data that will ultimately be discarded, wasting resources.

Keep practicing — related questions