Hello,
I have a simple package named as Test that assigns 1 if its success or 0 if its error to a variable based on mapping success:
And my load plan logic will use this 1 to run another procedure after passing the case when.
In my load plan I have no overwriting or refreshing, just I set the variables without touching.
However when I run the load plan without a mapping error, it still behaves like the variable is set to 0, but querying the repo or checking the history through the interface of that variable, I see 1 is assigned. Below is the load plan history, it did not go through case when step. It used ELSE. Also in this log my variable's current value is 0 starting from root_step entirely.
But variable is 1 :(!
So, is it not possible to set a variable value through package and use it inside the load plan? Does it set a default value for each session in load plan?
What am I doing wrong? Thank you very much.