My requirement is to load the surrogate key with sequence values. However i am restricted not to use the sequence generator and mapping variable. Is there any other way to generate the sequence numbers?
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.