Informatica Sequence Generator FAQ
Additional frequently asked questions about Informatica Sequence Generator beyond the main guide page.
Can I use multiple Sequence Generator transformations in one mapping?
Yes. Use a separate Sequence Generator for each target table that needs independent surrogate key ranges. Make sure each generator has a distinct start value range to prevent key collisions.
What happens to sequence values when a session fails?
Sequence Generator does not roll back values after failures. Gaps appear in the target key range because the generator advanced past the failed rows. Use the config guide's restart flow to realign start values after recovery.
Does Sequence Generator work with CDC or incremental loads?
Yes. It generates unique values regardless of load type. For CDC, make sure the generator runs in the same mapping path as the target insert. For incremental loads, set the start value above the existing maximum key.
Can Sequence Generator produce non-numeric values?
No. Sequence Generator outputs integer values only. For string-based keys, use an Expression transformation to concatenate a prefix with the generated number.