Operator Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Subscription Filters

To define the data that an automatic mapping subscription consumes, add a filter to the subscription. When you add a filter to a subscription, you can define filter conditions to table rows.

You can use basic expressions and advanced expressions to define filter conditions. You can use more than one method to add filters to a table row.

Basic Expression: Use this method if you want to apply a condition to a table row and the operators and values in the basic condition builder meet your requirements. For example, for an Orders table, add a condition that the date in the ShippedDate column is greater than April 1, 2015.
Advanced Expression: Add filter conditions to tables with PowerCenter expressions. For example, for an Orders table, add the following expression:

(ShipCountry=’USA’) and ((ShipCity=’New York’) or (ShipCity=’Los Angeles’))

The filters use an AND logic. If multiple filters exist for a table,

Data Integration Hub

writes only the rows that meet all of the conditions to the target.

For automatic database and flat file subscriptions, if data relations are defined for the topic to which the subscription subscribes, filters are applied to the tables for which relations are defined, and the subscriber consumes only the data that is defined by the data relations.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

Subscription Filters

Subscription Filters