How to generate surrogate key without using surrogate key stage?
Use the following formula in Transformer stage to generate a surrogate key.
@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM 1)) + 1
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!