parameters - Powercenter Parametrization error -


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