i trying parametrize expression variables in expression transformation. expressions follows:
in(emp_dept_cd, (‘12we3’,’lkow23’,’po234’,’iulyt34’),0)
rtrim(ltrim(emp_term_cd))=‘1234’ , emp_term_dt > sysdate
(or post session command replace sysdate sysdate - 8 months)
i replaced expressions follows:
in(emp_dept_cd, $$emp_cd_list,0)
rtrim(ltrim(emp_term_cd))=‘1234’ , emp_term_dt > $$emp_dt
my parameter file contains these variables as:
$$emp_dt = sysdate
$$emp_cd_list=(‘12we3’,’lkow23’,’po234’,’iulyt34’)
i getting transformation initialization error, , parsing error. also, have set in mapping variables , parameters isexprvar = true , the type parameter. apologize if using wrong terms here new parametrization.
thanks in advance
Comments
Post a Comment