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

Configuring the SQL Data Service Optimizer Level for Data Preview

Configuring the SQL Data Service Optimizer Level for Data Preview

Configure the optimizer level that the Data Integration Service uses to execute SQL queries when you preview the output of a SQL data service.
  1. In the Developer tool, click
    Run
    Open Run Dialog
    .
    The
    Run
    dialog box appears.
  2. Click
    Data Viewer Configuration
    .
  3. Click the
    New
    button.
  4. Enter a name for the data viewer configuration.
  5. Click the
    Advanced
    tab.
  6. Select an optimizer level.
  7. Click
    Apply
    .
  8. Click
    Close
    The Developer tool creates the data viewer configuration.

0 COMMENTS

We’d like to hear from you!