When you configure a Sequence Generator transformation, you can connect the NEXTVAL port to single or multiple ports in the transformations that follow the Sequence Generator transformation.
You can push a Sequence Generator transformation with the following restrictions:
You cannot use a shared sequence in a Sequence Generator transformation.
You can add only an Expression or a Target transformation after a Sequence Generator transformation in a mapping.