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

Evaluating Expressions

Evaluating Expressions

If you are not sure which expressions slow performance, evaluate the expression performance to isolate the problem.
Complete the following steps to evaluate expression performance:
  1. Time the session with the original expressions.
  2. Copy the mapping and replace half of the complex expressions with a constant.
  3. Run and time the edited session.
  4. Make another copy of the mapping and replace the other half of the complex expressions with a constant.
  5. Run and time the edited session.