top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Dynamic operators in where clause in Informatica [CLOSED]

0 votes
134 views

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

posted Jul 16, 2014 by Amit Sharma

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

...