topic Generating Unique sequence number when same job running in two different systems in Talend Studio

Generating Unique sequence number when same job running in two different systems

Anonymous — Wed, 03 Oct 2018 09:54:56 GMT

Hi,

I got stuck how to get the unique sequence number when the same job runs in two different machines at the same time in the same table. The sequence number should be unique and update the rows in the same table without any rows missed.

looking for any suggestions.

Thanks in Advance

Re: Generating Unique sequence number when same job running in two different systems

Anonymous — Wed, 03 Oct 2018 10:09:43 GMT

The only way to do this is to use a database sequence (if you can) or to hold the sequence in another location that both (all) jobs have access to. I generally use a database sequence to handle anything that requires a sequence that isn't reset after the job has finished running.

Re: Generating Unique sequence number when same job running in two different systems

Anonymous — Wed, 03 Oct 2018 10:53:34 GMT

Thank you for the quick reply

Can u please elaborate how would we implement in TDI for MSsql.

please help.

thanks,

raghav

Re: Generating Unique sequence number when same job running in two different systems

Anonymous — Wed, 03 Oct 2018 12:10:55 GMT

You need to set up a sequence in your database. Take a look here for that: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-2017

Then you need to use that sequence in Talend. To do that you can use a tMSSqlInput with code similar to below (assuming your sequence is called MySequence).

"SELECT NEXT VALUE FOR MySequence as seqnum"