Table of Contents

Search

  1. Preface
  2. Data Integration performance tuning overview
  3. Optimizing targets
  4. Optimizing sources
  5. Optimizing mappings
  6. Optimizing mapping tasks
  7. Optimizing advanced clusters
  8. Optimizing system performance

Data Integration Performance Tuning

Data Integration Performance Tuning

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 copy of the mapping, keep only the source transformations and any custom joins or queries.
  3. Remove all other transformations.
  4. Connect the sources to a flat file target.
Run the read test mapping. If the mapping performance is similar to the original run, you have a source bottleneck.

0 COMMENTS

We’d like to hear from you!