Informatica Config FAQ
Additional frequently asked questions about configuring the Informatica Sequence Generator beyond the main config guide page.
How do I handle multi-partition sessions with Sequence Generator?
Use increment by equal to the partition count and offset each partition's start value. For 4 partitions with increment=4: partition 1 starts at 1, partition 2 at 2, partition 3 at 3, partition 4 at 4. This guarantees unique keys without collisions.
What is the recommended restart strategy for daily batch loads?
Before each load, query the target table's maximum key, add a safety margin (e.g. +1000), and set that as the start value. This handles failed loads and makes retries safe. Document the procedure so operators can repeat it consistently.
Can end value be used for range enforcement?
End value is rarely needed for surrogate keys. It stops the generator after reaching a maximum, which can cause load failures if the range is exhausted. Leave it at the default unless you have a documented reason to cap key ranges.