In the Developer, tool you can add a Sequence Generator transformation to a mapping when you want to generate numeric values. Use the Sequence Generator transformation to create unique primary key values or to replace missing primary keys. You can also use the transformation to cycle through a sequential range of numbers.