Generating Row_number as key field for DB load

Anonymous — Sat, 16 Nov 2024 02:51:02 GMT

Hi,

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?

Sample data:

Run1:

Row_num

Run2:

Row_num

Re: Generating Row_number as key field for DB load

TRF — Sat, 28 Mar 2020 20:14:48 GMT

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.

topic Re: Generating Row_number as key field for DB load in Talend Studio

Generating Row_number as key field for DB load

Re: Generating Row_number as key field for DB load