Preface
Performance Tuning Overview
- Performance Tuning Overview
Bottlenecks
Optimizing the Target
Optimizing the Source
Optimizing Mappings
Optimizing Transformations
Optimizing Sessions
Optimizing Grid Deployments
Optimizing the PowerCenter Components
Optimizing the System
Using Pipeline Partitions
Performance Counters

Performance Tuning Guide

10.4.0
- 10.5

Back Next

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:

Make a copy of the original mapping.

In the copied mapping, keep only the sources, source qualifiers, and any custom joins or queries.

Remove all transformations.

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.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Using a Read Test Mapping

Using a Read Test Mapping