topic Re: Generating primary key sequence number for incremental load in Talend Studio

Generating primary key sequence number for incremental load

Anonymous — Tue, 05 Nov 2019 13:57:09 GMT

I am using numeric sequence to generate primary key in a sequence. This works okay for a total load.

But if I have to do any updates, then it overwrites the existing values.

I tried using Numeric.sequence("s1",(integer)globalMap.get("maxrow"),1).

I used taggregateRow to get the max of the particular column and directed it to tsetGlobalVar but whenever I run the job, I get the error that numeric sequence accepts only integer and not object.

Can anyone help me through this? Or are there any better way to do this?

Re: Generating primary key sequence number for incremental load

TRF — Tue, 05 Nov 2019 17:06:30 GMT

Try this one:

Numeric.sequence("s1",(Integer)globalMap.get("maxrow"),1)

Re: Generating primary key sequence number for incremental load

Anonymous — Wed, 06 Nov 2019 06:54:33 GMT

Hi,

Thanks. It works now.

Re: Generating primary key sequence number for incremental load

Anonymous — Wed, 06 Nov 2019 10:14:16 GMT

Hi,

I still have an issue. I am passing my rows through taggregate row and getting the max using tsetvariable. But when I call the global variable inside my expression builder, its value is null but when I pass it through tlogrow, it gives the correct value. Can you help me with this?