SCD type

[akumar2]

Hi Everyone,

I am trying implement SCD type1 in my project. I have created and run the job without context variables i my then it was running successfully, but i am trying to run the job with the use of context variables, i am getting error like "Cannot cast to boolean: "10.21203/rs.3.rs-2885744/v1" " i dont know why it was happening. i have checked the column data type every thing is correct.  Please find the attached job screenshot.

Thanks in advance.

[Shicong_Hong]

Hi  

It expects a boolean value but it is a string. Can you show us where do you use the context variable? 

Regards

Shong

[Kaushik]

Can you please? share the more details of the job and also check the data types once again?

[akumar2]

Hi shong88,

Please find the attached SS for the context variable i have created and where i am using. I am assing values to my context variable using tjavarow from different table.

[akumar2]

Hi kaushik, 

                          i have checked the datatype of my source and target, both are sting form only.

i am assigning values to my context variable using tjavarow and using these context variable to fetch data from source to target . I will share the ss of myjob.

[Shicong_Hong]

Need to further confirm which component the error occurred on, check the 'die on error' option on DB components, the error will be thrown out on the console.

[akumar2]

Hi Shong88,

                           The error was resolved and I am getting output.

Thankyou @Shicong_Hong