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.
Can I migrate a PowerCenter mapping with Sequence Generator to IICS?
Yes, but review the configuration. IICS mappings have fewer configuration options than PowerCenter for Sequence Generator. The core behavior stays the same, but some advanced settings like cache size may not transfer directly.
Related