Dynamic operators in where clause in Informatica?

Question

Is it possible to create dynamic sql operator in Informatica using SQL Transformation. For eg.

SELECT p.id 
FROM products p
WHERE p.weight ?operator? '30'
where ?operator? can have values: <, > , =

or even: in, not in

Answer 1

The SQL Editor window of SQL Transform allows to use parameter binding (?parameter?) and string substitution (~string~). You need the later:

SELECT p.id 
FROM products p
WHERE p.weight ~operator~ '30'

Answer 2

Just as an alternative, you can use a parameter for the whole condition like -
$$sq_param = p.weight > '30'