Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Second source filters

Second source filters

You can apply filter conditions to filter the combined data.
You can configure the following types of filters:
Simple
To configure a filter condition, select a source field and configure the operator and value to use in the filter. You can select a field from either source. Fields from the original source are prefixed with the characters
SRC_
or
IN_SRC_
.
When you define more than one filter condition, the task evaluates them in the order that you specify. The task evaluates the filter conditions using the AND logical operator to join the conditions. It returns rows that match all the filter conditions.
Advanced
Create a filter expression using the expression editor. You enter one expression that contains all filters. You can use source fields and built-in functions in the expression.
For more information about advanced filters, see Advanced data filters.

0 COMMENTS

We’d like to hear from you!