Data Warehousing and Computer Hardware

Casual Mode - Take your time!

1 / 20
Correct
0
Incorrect
0
Score
0%
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