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. Appendix A: Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Optimizing Integration Service Performance

Optimizing Integration Service Performance

Complete the following tasks to improve Integration Service performance:
  • Use native drivers instead of ODBC drivers for the Integration Service.
  • Run the Integration Service in ASCII data movement mode if character data is 7-bit ASCII or EBCDIC.
  • Cache PowerCenter metadata for the Repository Service.
  • Run Integration Service with high availability.
When you configure the Integration Service with high availability, the Integration Service recovers workflows and sessions that may fail because of temporary network or machine failures. To recover from a workflow or session, the Integration Service writes the states of each workflow and session to temporary files in a shared directory. This may decrease performance.

0 COMMENTS

We’d like to hear from you!