To design a filter clause, you can specify the column names in the target table and any transformation language functions that use the column names as arguments. To set multiple criteria, use the operators AND and OR. The filter clause must evaluate to TRUE or FALSE.

For example, you ingest the following source table:

EMPLOYEEID	PHONENUMBER
607014	(630)4468851
620368	(904)3854084
698107	(549)5694371
621861	(904)9062721

You want to filter the rows that you ingest to the target. You can use the following filter clause to filter the rows by area code

(904)

:

RTRIM(PHONENUMBER, REG_EXTRACT(PHONENUMBER, '.*([0-9]{7})$')) = '(904)'

The rows in the table are filtered by area code

(904)

. The following table is ingested to the target:

EMPLOYEEID	PHONENUMBER
620368	(904)3854084
621861	(904)9062721

For more information on transformation language functions, see the "Functions" chapter in the

Informatica Transformation Language Reference

.