topic Re: Incremental Surrogate Key in Talend Studio

Incremental Surrogate Key

abhi90 — Tue, 23 Jan 2018 16:44:37 GMT

We have an column in Database which is Primary Key. We want to load this using Numeric.sequence(s1,1,1) But problem is in 2nd Run the value of column will start again from 1. How to start it after the last Value generated in Last Run.

Re: Incremental Surrogate Key

Anonymous — Tue, 23 Jan 2018 17:00:55 GMT

Try to get the max value of the primary key column from that table at the start of the job, Store it in a variable and then increment it for each record.

Re: Incremental Surrogate Key

abhi90 — Tue, 23 Jan 2018 17:16:26 GMT

Let's Say I am taking Max(column) in toraclerow at the start of the Job.So in tmap is it should be like Numeric.sequence(s1,Max(Column),1)?

Re: Incremental Surrogate Key

Anonymous — Tue, 23 Jan 2018 17:27:37 GMT

Yes Abhi.

Re: Incremental Surrogate Key

Anonymous — Mon, 11 Mar 2019 10:58:20 GMT

Hi @manishrnjn how can we store int value in Context Variable.

can you please explain, bcaz am getting an error if i declare variable as int.

PFA screenshot

Capture.PNG
Capture_1.PNG

Re: Incremental Surrogate Key

Anonymous — Tue, 12 Mar 2019 01:22:33 GMT

Hi,

Currently you are storing the data of Context variable from same variable.

This will create issue. Could you please read the data from database and assign it to context variable through a tjavarow.

tDBInput->tJavarow

context.variable=input_row.max_value;

In this way, the data will be loaded to context variable. After that, you can assign this context variable within sequence.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Incremental Surrogate Key

Anonymous — Tue, 12 Mar 2019 06:42:01 GMT

Hi @nthampi

I tried it but am getting the same error.

Can you please explain in detail.

Re: Incremental Surrogate Key

Anonymous — Wed, 13 Mar 2019 19:17:07 GMT

Hi,

Could you please share the new job flow screen shots after change along with context tab screenshot for reference?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂