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

Optimizing the PowerCenter Components Overview

Optimizing the PowerCenter Components Overview

You can optimize performance of the following PowerCenter components:
  • PowerCenter repository
  • Integration Service
If you run PowerCenter on multiple machines, run the Repository Service and Integration Service on different machines. To load large amounts of data, run the Integration Service on the higher processing machine. Also, run the Repository Service on the machine hosting the PowerCenter repository.