Question 1

How do I handle multi-partition sessions with Sequence Generator?

Accepted Answer

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.

Question 2

What is the recommended restart strategy for daily batch loads?

Accepted Answer

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.

Question 3

Can end value be used for range enforcement?

Accepted Answer

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.

配置 FAQ

起始值应该设为多少?

增量可以大于 1 吗?

重启映射会重复键吗?