I'm new to talend and in the process of learning it. I came across a problem where the DB table has to be loaded with data which doesn't have a key column. I want to add a row_num which would act as the key value. The issue is the Row_num needs to be continuous from the previous run.
I could use the tRow_generator to generate the row_num. But how to configure it to generate values starting from the previously generated Row_num between runs? Can anyone help please?
Select the current max value from the dB and store the result into a global variable. Then use a numeric.sequence with a start value based on the global variable value + 1. No need of tRowGenerator.
