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

Configuring the data filters

Configuring the data filters

Use a data filter to reduce the number of source rows that the
synchronization
task reads for the task. By default, the
synchronization
task reads all source rows.
  1. On the
    Data Filters
    page, choose whether to read all rows in sources or to read the first set of rows in sources.
    • To read all rows, select
      Process all rows
      .
    • To read the first set of rows, select
      Process only the first
      and enter a number.
  2. To create a data filter, click
    New
    .
    • To create a simple data filter, select a source column and operator. Enter the value you want to use, and click
      OK
      .
    • To create an advanced data filter, click
      Advanced
      . Enter the field expression you want to use and click
      OK
      .
    You can use parameters defined in a parameter file in data filters. When you use a parameter in a data filter, start the data filter with the parameter. For example, use
    $$Sales < 100000
    instead of
    100000 > $$Sales
    .
    To delete a data filter, click
    Delete
    .
  3. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!