English
  • PowerCenter 10.4.0
  • All Products

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

Back Next

Optimizing Lookup Transformations

Optimizing Lookup Transformations

If the lookup table is on the same database as the source table in your mapping and caching is not feasible, join the tables in the source database rather than using a Lookup transformation.
If you use a Lookup transformation, perform the following tasks to increase performance:
  • Use the optimal database driver.
  • Cache lookup tables.
  • Optimize the lookup condition.
  • Filter lookup rows.
  • Index the lookup table.
  • Optimize multiple lookups.
  • Create a pipeline Lookup transformation and configure partitions in the pipeline that builds the lookup source.