Informatica power center parameters with multiple values

Question

I have this filter in SQL:

WHERE DEP_NAME IN ( 'SALES','ACCOUNTING')

How can I pass these two values in a mapping parameter in order to use in in the mapping either in SQ or FILER TRANSFORMATION.

Thank you.

Answer 1

You can pass all values in IN clause using a parameter.

1. define a parameter like this $$FILTER_CLAUSE= 'SALES','ACCOUNTING'
2. use it in your SQL - WHERE DEP_NAME IN ( $$FILTER_CLAUSE )

This will work in SQ and FIL. You can pass as many values as you want.