topic Persistent Sequence Generation in Talend Studio

Persistent Sequence Generation

Anonymous — Thu, 31 Dec 2015 16:57:34 GMT

Hi - I am looking for some component that can be shared across jobs while generating the next value of Sequence.
I found the below link on help page. But this appears to be a non-persistent way which will increment everytime from the value set.
https://help.talend.com/search/all?query=How+to+create+a+Sequence&content-lang=en
Below is my requirement.
I need to get the next value of sequence in parallel and use it in my jobs, while getting the next value i need to ensure that the value is not duplicated for different jobs and is always unique. The sequence is not per row but for Job.
Eg: While generating the Sequence in Parallel for 4 Jobs:
Job 1 - Sequence Value = 1
Job 2 - Sequence Value = 2
Job 3 - Sequence Value = 3
Job 4 - Sequence Value = 4
Thanks,

Re: Persistent Sequence Generation

Anonymous — Thu, 31 Dec 2015 17:37:34 GMT

Does it have to be a sequence?
You could use UUID (String 36).
import java.util.UUID;
public static String getUUID() {
return UUID.randomUUID().toString();
}
if you need a sequence, you probably either have to externalise the generation to something like a database or use Talend's sequence method; but have to start passing initial values around your Jobs.

Re: Persistent Sequence Generation

Anonymous — Thu, 14 Jan 2016 00:55:03 GMT

Hi -
Unfortunately i cannot rely on the database as sequences are disabled. Is there anything similar to informatica sequence generator transformation we can use in talend to push the key generation with auto-increment by storing the last incremented value persistently within talend?
Thank you.