Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Bottlenecks
  4. Optimizing the Target
  5. Optimizing the Source
  6. Optimizing Mappings
  7. Optimizing Transformations
  8. Optimizing Sessions
  9. Optimizing Grid Deployments
  10. Optimizing the PowerCenter Components
  11. Optimizing the System
  12. Using Pipeline Partitions
  13. Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Eliminating Source Bottlenecks

Eliminating Source Bottlenecks

Complete the following tasks to eliminate source bottlenecks:
  • Set the number of bytes the Integration Service reads per line if the Integration Service reads from a flat file source.
  • Have the database administrator optimize database performance by optimizing the query.
  • Increase the database network packet size.
  • Configure index and key constraints.
  • If there is a long delay between the two time measurements in a database query, you can use an optimizer hint.