Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Target Optimization
  4. Source Optimization
  5. Transformation Optimization
  6. Mapping Optimization
  7. Partitioned Mapping Optimization
  8. Run-time Optimization
  9. SQL Data Service Optimization
  10. Web Service Optimization
  11. Connections Optimization
  12. Data Transformation Optimization

Performance Tuning Guide

Performance Tuning Guide

Enabling Push-Into Optimization with the SQL Transformation

Enabling Push-Into Optimization with the SQL Transformation

Enable push-into optimization by configuring properties on the SQL transformation
Advanced Properties
tab.
  1. Clear
    Has Side Effects
    .
  2. Enable
    Return Database Output Only
    .
  3. Set
    Max Out Row Count
    to zero.
  4. Enable push-into optimization.

0 COMMENTS

We’d like to hear from you!