Question

Informatica: What is a Sequence Generator Transformation?

Answer 1

The Sequence Generator Transformation in Informatica is a connected transformation that generates numeric values. We can mainly use this transformation to generate primary keys, foreign keys or to fill or replace the missing primary keys with unique ones.

Answer 2

A Sequence Generator Power Center - Transformations generates unique values, such as primary keys, for a target in a mapping. You can also use it to cycle through a closed set of values. ... The Sequence Generator transformation functions like a sequence object in a database