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

Optimizing the lookup condition

Optimizing the lookup condition

If you include more than one lookup condition, place the conditions in an optimal order to increase lookup performance.
Use the following order:
  1. Equal to (=)
  2. Less than (<), greater than (>), less than or equal to (<=), greater than or equal to (>=)
  3. Not equal to (!=)

0 COMMENTS

We’d like to hear from you!