topic Re: Null value will be used for context parameter SOURCE_ID: For input string: "context.SOURCE_ID" in Talend Studio

Null value will be used for context parameter SOURCE_ID: For input string: "context.SOURCE_ID"

SREE3 — Tue, 14 May 2019 10:52:17 GMT

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.

Re: Null value will be used for context parameter SOURCE_ID: For input string: "context.SOURCE_ID"

manodwhb — Tue, 14 May 2019 15:29:33 GMT

@SREE ,how are you loading the those context parameters?

Re: Null value will be used for context parameter SOURCE_ID: For input string: "context.SOURCE_ID"

SREE3 — Wed, 15 May 2019 07:25:29 GMT

I am implementing the SCD on table ,so I am taking the max value of that column at the start of the job and storing it in the context variable (X),which i declared as int .Now that context variable i am assigning in the numeric sequence as " Numeric.sequnce('s1',X,1) ".

Though I get above warning I am able to load data into the table . The problem arises when I load multiple tables in the same job and use tdie component ,the job will stopped instead of loading the next table.

Regards,

Sreelekha