Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@SREE ,how are you loading the those context parameters?
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