How to generate sequence of numbers to get surrogate key

[Venkata_Sivaji1]

Team,

I am new to talend. I need help in below scenario.

I have a simple job case like below.

Job :- Job_Product_Details_Data_Details.

Above job will run on weekly basis and monthly basis.So when it run on first week , it should generate sequence number through the below function.And assume some number 1 to 100 created.From next run it should create from 101 and so on.

Function :- numeric.sequence("s1",1,1) 

I want to create from 101 and so on from next week run so i used below function in job instead of above function. But it is throwing compilation error.

Function :- numeric.sequence("s1",s1.nextval,1) 

Is there any functionality  in talend to call data base sequence to get sequence.nextval()?.

Thanks in Advance!

[TRF · Accepted solution]

You need to use the tDB component related to your database engine to access the current or next sequence value. Else, store the last used value into a file when the job finished.