topic Re: Sequence Generator not working properly. in Talend Studio

Sequence Generator not working properly.

Anonymous — Tue, 11 Sep 2018 12:37:23 GMT

I am trying to use sequence generator in tMap with the below syntax.

Sequence_Generator.sequence("s1",1,1)

If my input has 10 rows, it gives me a correct sequence number starting from 1 to 10 but if i delete my output filer and re-run the job, again it starts with 1 rather than starting with 11.

Can anyone please help here?

Thanks in Advance!

Re: Sequence Generator not working properly.

fdenis — Tue, 11 Sep 2018 12:47:38 GMT

your Sequence Generator can only see the job thread (it run on thread memory).
Il you want a permanent index you have to store it into file or database.
Regards,

Re: Sequence Generator not working properly.

Anonymous — Tue, 11 Sep 2018 12:50:29 GMT

Is there no component similar to sequence generator transformation in informatica?

Re: Sequence Generator not working properly.

fdenis — Tue, 11 Sep 2018 12:58:44 GMT

you can do it adding Sequence Generator to offset but you have to store offset.
I think informatica store offset in db.

BUT
if it's to have an unique id in db you have to generate it on db (getNextId or auto inrement) .
if it's to Have an id in file you have to open file get the max id then insert data.
if it use to merge or reive data in hashmap use local sequence generator .

what do you need?

Re: Sequence Generator not working properly.

Anonymous — Tue, 11 Sep 2018 13:02:45 GMT

I wanted to store this as an offset somewhere. I was checking if Talend have some inbuilt component to do it.

Will tAddCRCRow Component would help in this case?

Re: Sequence Generator not working properly.

fdenis — Tue, 11 Sep 2018 13:20:17 GMT

why not.
but,why dont you use a db sequence?
if you need uuid you can also write a function.!

Re: Sequence Generator not working properly.

TRF — Tue, 11 Sep 2018 13:21:15 GMT

I suggest you to store it as a context variable.

See tContextDump / tContextLoad components for that.

Re: Sequence Generator not working properly.

Anonymous — Tue, 11 Sep 2018 13:23:00 GMT

Thank you so much for all your replies!!

I think I might have to use a context variable..

Re: Sequence Generator not working properly.

TRF — Tue, 11 Sep 2018 13:26:24 GMT

This link may help you https://community.talend.com/t5/Design-and-Development/store-the-dynamic-values-in-context-variable/m-p/127366