Informatica IN Clause

Post date: 08-Jun-2015 14:20:07

Powercenter has an IN function. For full details look in the help where it is fully described with examples. 

Format is: IN(LOCATION, 'Dallas', 'New York', 'London) so is different to most formats of SQL. Only exception is if you are putting the expression in the user filter of a source qualifier for a relational source when you have to use the correct SQL format for that source database.

Ref: https://www.linkedin.com/grp/post/39237-88580897