Table of Contents

Search

  1. Preface
  2. Introduction to Mass Ingestion
  3. Prepare
  4. Create
  5. Deploy
  6. Run
  7. Monitor
  8. infacmd mi Command Reference

Mass Ingestion Guide

Mass Ingestion Guide

Filter Clauses

Filter Clauses

The filter clause determines how rows are filtered in the target table based on criteria for a column in the table.
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
.

0 COMMENTS

We’d like to hear from you!