Hello forum.
I have a variable in ODI whose value will be pretty static/persistent. So, I'd like to define it once and make it visible within all packages/scenarios that will use it.
Also, I'd like to define it in a single place, so that if it does change later, I'll have one place to go to, to change it. So, I'd like to avoid defining a "set variable" type with a literal in each package.
I could have done a refresh variable with a query like SELECT '<my-static-value>' FROM DUAL, but that's a trip to the database for every call in every package. I'd like something more performant than that.
I tried just setting the default value in the variable to my static value, but I noticed that when I run my packages using that variable, the default value is never resolved, regardless of the type I make the variable in the package (I tried refresh variable, set variable, declare variable).
So, why is the default value not kicking in? And if it's not the right thing to use, is there an alternative?
Thank you
Boris