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.