Hi
I have a requirement to have more then 30 ODI Refresh variables in a package, instead of having that many variable steps in a package and along with that each refresh variable is Database session and I don't want to do like that.Is it any way we can refresh all this variables in one go in ODI procedure?
Say for example my source tab sql and odi procedure will be like:-
select no as NO from xxx
union
select name as NAME from xxx
union
select address as ADDRESS from xxx
effectively all this sql's are refresh variable sql's
and on target tab of odi procedure , I need to assign source values to ODI Variables like #no,#name,#address something like that.
and call this ODI Procedure as 1st step in ODI Package as variable initialisation step.
I think we can do using Java Bean Shell Technology on the target tab?
Is it possible?Any input will be appreciated.
Cheers