📚 Practice Mode

Data Warehousing and Computer Hardware

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Answers

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
Change Mode