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. (i)Session performance is not affected

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

Placing filters near the source reduces the volume of data processed through subsequent ETL transformations. This minimizes overall network overhead and resource utilization, maximizing performance compared to filtering near the target.