topic Re: Sequence number Generation in Talend Studio

Sequence number Generation

Anonymous — Mon, 16 Sep 2013 12:01:43 GMT

Hi,
can any one provide solution for how generate the sequence number. for example i have used in expression "SEQ-"+Numeric.sequence("s1",1,1).toString for generating String sequence like SEQ-1. but its generating random sequence .
Thanks ,
Venkateswarlu.

Re: Sequence number Generation

Anonymous — Mon, 16 Sep 2013 13:19:08 GMT

sounds odd. Are you sure it's random?
Are you making multiple references to Numeric.sequence("s1",1,1) and incrementing it where you don't expect?
Also consider that the sequence is static and spans "child" Jobs.

Re: Sequence number Generation

Anonymous — Mon, 16 Sep 2013 13:26:23 GMT

Hi,
Yes sure , Its generating Random number.

Re: Sequence number Generation

Anonymous — Mon, 16 Sep 2013 13:34:13 GMT

I don't believe they can be "random".
The sequence number generation is very simple.
I think you're incrementing it unknowingly.
What are the first 10 keys being generated?
Do you have a multi-threaded Job?

Re: Sequence number Generation

Anonymous — Tue, 21 Apr 2015 07:35:48 GMT

How to generate Unique batch ID for each batch JOb run?
Thanks,
Rajitha