Question 1

Can I use multiple Sequence Generator transformations in one mapping?

Accepted Answer

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.

Question 2

What happens to sequence values when a session fails?

Accepted Answer

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.

Question 3

Does Sequence Generator work with CDC or incremental loads?

Accepted Answer

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.

Question 4

Can Sequence Generator produce non-numeric values?

Accepted Answer

No. Sequence Generator outputs integer values only. For string-based keys, use an Expression transformation to concatenate a prefix with the generated number.

Informatica 数列生成器 FAQ

一个映射中可以使用多个数列生成器转换吗?

数列生成器会与数据库序列冲突吗?

映射失败后键会回滚吗?