topic Re: Single UUID for every job run in Talend Studio

Single UUID for every job run

Anonymous — Thu, 19 May 2016 00:21:21 GMT

The following post describes on how to get a different UUID for each row inserted to Database table.

When I run a rob, number of rows that gets inserted to DB differs. On every run, I want to insert the same UUID for every row that is inserted on that particular job run. (One UUID for every job run). How to achieve this?

Re: Single UUID for every job run

Anonymous — Thu, 19 May 2016 10:36:21 GMT

Talend itself provides such a UUID called talendPid. This is a member variable in every job. The problem here is, it is not entirely unique over a long time. I suggest you add a timestamp on it and this makes it absolut unique.

Re: Single UUID for every job run

Anonymous — Thu, 19 May 2016 10:42:22 GMT

WAIT ! talendPid is not even close to an UUID ( see UUID Specifications)

you can use java.util.UUID https://docs.oracle.com/javase/7/docs/api/java/util/UUID.html
in the beginning of your Job put it into th globalMap and use it as needed

cheers

Re: Single UUID for every job run

Anonymous — Thu, 19 May 2016 10:43:37 GMT

Yep, this is also a good way. There are plenty of classes providing a secure unique UUID.
Me and my colleagues have designed a concept and dedicated components to create such UUID based on a database sequence and also with a lot of stuff to steer the jobs and measure the metrics.
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252F1%252Fproducts%252F556%252Fitems%252F2433
Take a look at the documentation before check it out.

Re: Single UUID for every job run

Anonymous — Thu, 19 May 2016 11:06:23 GMT

Before you insert, place a UUID on the globalMap and then insert it.
You can create this in tJava and then map it in tMap, for example: -
tJava(onSubjobOK)->tFileInputDelimited(row1)->tMap(row2)->tMySQLOutput
In tJava, add something like: -
globalMap.put("UUID", java.util.UUID.randomUUID().toString());