When you run a session configured for target-side pushdown optimization, the
Integration Service analyzes the mapping from the target to the source or until
it reaches an upstream transformation it cannot push to the target database. It
generates an INSERT, DELETE, or UPDATE statement based on the transformation
logic for each transformation it can push to the target database. The
Integration Service processes the transformation logic up to the point that it
can push the transformation logic to the database. Then, it executes the
generated SQL on the target database.
No comments:
Post a Comment