Tasks

Back Next

Data filter operators

You can use specific operators with each field type.

For mappings in SQL ELT mode, use operators that are valid in your cloud data warehouse's expression language. For more information, see the documentation for your cloud data warehouse. For other types of mappings, use the Informatica transformation language operators that are listed in the following table.

The following table shows the operators you can use for each field type:

Field type	Operators
Boolean	=, !=, Is Null, Is Not Null
Currency	=, !=, <, <=, >, >=, Is Null, Is Not Null
Date	=, !=, <, <=, >, >=, Is Null, Is Not Null
Datetime	=, !=, <, <=, >, >=, Is Null, Is Not Null
Double	=, !=, <, <=, >, >=, Is Null, Is Not Null
ID	=, !=, Is Null, Is Not Null
Int	=, !=, <, <=, >, >=, Is Null, Is Not Null
Reference	=, !=, Is Null, Is Not Null
String	=, !=, LIKE'_%', LIKE'%_', LIKE'%_%', Is Null, Is Not Null, <, <=, >, >=
Textarea	=, !=, LIKE'_%', LIKE'%_', LIKE'%_%', Is Null, Is Not Null, <, <=, >, >=
All other field types	=, !=, Is Null, Is Not Null