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

[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.

[manodwhb]

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

[SREE3]

Hi 

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