Generation of Surrogate key for Incremental Load

[Anonymous]

Hi,

I have a column in a table in table for which am generating a surrogate value by using Numeric.sequence("S1",1000,1). This works fine for the 1st time but for the second time, I want it to  take max value form the last generated surrogate value. Here I am taking the max of that column into a context variable and using in the tmap Numeric.sequence("S1",Max(Column_Name),1).

Here I am facing an issue. Context variable is not accepting the int value in it. I am getting error.

Can you please help me solve this issue.

Thanks in advance

ShaX

[Anonymous]

Any help on this plzz.

[manodwhb · Accepted solution]

@ShaX ,can you just set a some value like 1 for that context,you will not get the warring. 

[SREE3]

Hi All,

I am implementing SCD on my table ,i am trying to generate surrogate id using numeric sequence. 

To do this at the start of the job I am taking max of value and storing it in a context variable "context.SOURCE_ID".This context I am using in the numeric sequence. I am getting this error

PFA image.

Regards,

Sreelekha.