Operator
| Description
| Example
|
---|---|---|
AND
| Evaluates two conditional expressions and:
| MATCH_PATH_COMPONENT.C_MT_ADDRESS|CITY_NAME = 'New York' AND COLUMN.C_PARTY|ORGANIZATION_NAME = 'Informatica LLC' |
OR
| Evaluates two conditional expressions and:
| MATCH_PATH_COMPONENT.C_MT_ADDRESS|CITY_NAME = 'London' OR MATCH_PATH_COMPONENT.C_MT_ADDRESS|CITY_NAME = 'Paris' |
NOT
| Negates the conditional expression that follows.
| MATCH_PATH_COMPONENT.C_MT_ADDRESS|COUNTRY_CODE = 'USA' and NOT MATCH_PATH_COMPONENT.C_MT_ADDRESS|CITY_NAME = 'Los Angeles' |