Multiple choice technology

If a session is configured for full pushdown optimization then

  1. The Integration Service pushes as much transformation logic as possible to the source database

  2. The Integration Service pushes as much transformation logic as possible to both source and target database

  3. If the Integration Service cannot push all the transformation logic to the database, it performs partial pushdown optimization

  4. If the Integration Service cannot push all the transformation logic to the database, it fails the session
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Full pushdown optimization in Informatica pushes transformation logic to both source and target databases when possible. If not all logic can be pushed to the database, the Integration Service performs partial pushdown optimization rather than failing the session. Option A is incorrect because it only mentions source database.

Keep practicing — related questions