Multiple choice technology platforms and products

Push down optimization can be configured using

  1. source-side pushdown optimization

  2. target-side pushdown optimization

  3. full pushdown optimization

  4. All the Above

  5. None of the above

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

Pushdown optimization in Informatica improves performance by pushing transformation logic to the database. Source-side pushdown executes logic near the source database. Target-side pushdown executes near the target. Full pushdown pushes the entire transformation logic to the database. All three modes are valid configuration options for pushdown optimization.