- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SCD type
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.
- Tags:
- scd
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
It expects a boolean value but it is a string. Can you show us where do you use the context variable?
Regards
Shong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content