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.