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 Early Selection Optimization with the SQL Transformation

Enabling Early Selection Optimization with the SQL Transformation

Enable early selection optimization in the SQL transformation if the SQL transformation has no side effects.
  1. Enable the
    Return Database Output Only
    option in the SQL transformation
    Advanced Properties
    .
  2. Clear
    Has Side Effects
    in the transformation
    Advanced Properties
    .
  3. If the transformation has a
    NumAffectedRows
    port, remove the port.

0 COMMENTS

We’d like to hear from you!