Thread: Create a sequence without using mapping variables and sequence generator - Informatic

Follow the below steps:

create a mapping to write the max value of the surrogate column of the target table into a parameter file.
Now use this parameter file in the required mapping.
Now increment the value of the parameter in an expression transformation and pass it to the surrogate port of the target.