Sequence Generator not working properly.

[Anonymous]

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!

[fdenis]

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,

[Anonymous]

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

[fdenis]

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?

[Anonymous]

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?

[fdenis]

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

[TRF]

I suggest you to store it as a context variable.

See tContextDump / tContextLoad components for that.

[Anonymous]

Thank you so much for all your replies!!

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

[TRF]

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