FAQ
IICS Sequence Generator FAQ
Additional frequently asked questions about Sequence Generator in Informatica Intelligent Cloud Services.
How does IICS Sequence Generator handle concurrent task runs?
Each task instance maintains its own sequence state. For concurrent runs writing to the same target, use database-native sequences instead of the ETL-side generator to prevent key collisions between parallel processes.
Can I use Sequence Generator in a Data Integration mapping template?
Yes. Sequence Generator works inside mapping templates the same way as in individual mappings. The generated values are scoped to each template instance execution.
What happens to sequence state when a mapping task is paused and resumed?
The sequence continues from its last emitted value. No values are skipped during a clean pause-resume cycle. Unclean interruptions (task crashes) follow the same gap behavior as PowerCenter.
Related Pages