Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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 Sequence Generator transformations

Optimizing Sequence Generator transformations

To optimize Sequence Generator transformations, create a reusable sequence generator and use it in multiple mappings simultaneously. Also, configure the number of values to cache at one time.
Ensure that the number of values to cache isn't too small. Consider configuring the number of values to a value greater than 1,000.
If you don't need to cache values, set the number of values to cache to 0. Sequence Generator transformations that don't use a cache are faster than those that require caching.
When you connect the CURRVAL field in a Sequence Generator transformation,
Data Integration
processes one row in each block. You can optimize performance by connecting only the NEXTVAL field in a mapping.

0 COMMENTS

We’d like to hear from you!