Operator Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Step 5. Define a Filter

To define the data that an automatic relational database or flat file publication publishes, add a filter to the publication. When you add a filter to a publication, 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, 2016.
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

publishes only the rows that meet all of the conditions.

Choose the type of expression that you want to create.

Select the table to which to apply the filter from the

Select Table

list.

Enter the condition parameters according to the method that you selected:

Basic expression: go to step 4.

Advanced expression: go to step 5.

To create a basic expression, perform the following steps:

Select the column to filter from the

Select Column

list.

Select the filter operator from the

Select Operator

list.

The available operators depend on the type of content in the column.

When

Select Value

is enabled, select or enter a value for the operator.

Click the plus icon to the right of the expression line.

The condition shows in the condition list.

To create an advanced expression, perform the following steps:

Enter a valid PowerCenter expression in the text field. Alternatively, prepare a basic expression, select

Advanced Expression

, and then, in the expression text area, complete the expression.

The expression is limited to the selected table. The expression can contain up to 1024 characters.

Click the plus icon to the right of the expression line.

The condition shows in the condition list.

Repeat steps 1 through 5 to add the required conditions.

Click

The

Schedule

page appears.

Creating an Automatic Relational Database Publication

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

Step 5. Define a Filter

Step 5. Define a Filter