IICS
IICS Sequence Generator
In IICS, Sequence Generator still solves surrogate-key creation, but the surrounding mapping experience is cloud-native and lighter.
Key Differences
- The transformation is configured inside a cloud mapping instead of a PowerCenter repository object.
- Use it when target rows need generated IDs during ingestion, staging, or dimensional loads.
- The core intent stays the same: stable, generated numbers inside the ETL flow.
IICS vs PowerCenter
| Area | IICS | PowerCenter |
|---|---|---|
| Authoring | Cloud mapping designer | Desktop repository tools |
| Typical use | Cloud pipelines and synchronized loads | On-prem ETL and warehouse feeds |
| Generator goal | Generated surrogate keys | Generated surrogate keys |
Typical Mapping Setup
- 1Create or open the IICS mapping task.
- 2Add Sequence Generator where the row stream needs generated values.
- 3Map the generated output to the target key column.
- 4Validate the target load with a short sample run before the full task.
Code
Simple cloud mapping flow
Source -> Expression -> Sequence Generator -> TargetFAQ
Does IICS Sequence Generator replace database sequences?
No. It is an ETL-side generator, useful when you want the mapping to control ID assignment.
When should I use a database sequence instead?
Use database-native sequences when the warehouse owns the key lifecycle or multiple loaders must share one source of truth.
Related