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

Using a Read Test Mapping

Using a Read Test Mapping

You can create a read test mapping to identify source bottlenecks. A read test mapping isolates the read query by removing the transformation in the mapping.
To create a read test mapping, complete the following steps:
  1. Make a copy of the original mapping.
  2. In the copied mapping, keep only the sources, source qualifiers, and any custom joins or queries.
  3. Remove all transformations.
  4. Connect the source qualifiers to a file target.
Run a session against the read test mapping. If the session performance is similar to the original session, you have a source bottleneck.