topic Re: SCD type in Talend Studio

SCD type

akumar2 — Wed, 31 Jan 2024 08:01:12 GMT

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.

Re: SCD type

Shicong_Hong — Thu, 01 Feb 2024 05:29:08 GMT

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

Regards

Shong

Re: SCD type

Kaushik — Thu, 01 Feb 2024 06:10:28 GMT

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

Re: SCD type

akumar2 — Thu, 01 Feb 2024 06:40:26 GMT

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.

Re: SCD type

akumar2 — Thu, 01 Feb 2024 06:45:10 GMT

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.

Re: SCD type

Shicong_Hong — Mon, 05 Feb 2024 01:43:24 GMT

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.

Re: SCD type

akumar2 — Mon, 05 Feb 2024 09:26:42 GMT

Hi Shong88,

The error was resolved and I am getting output.

Thankyou @Shicong_Hong