Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Step 4. Define Topic Table Relations

You can define relations between topic tables, to filter the data that automatic database and flat file subscriptions consume from the topic

in the

Table Relations

page of the

New Topic

wizard. You can also define filter accelerators for topics that you plan to use for unbound subscriptions.

In the

Show

list, you can select to show all topic tables or to show a specific table.

In the

Filter Accelerator

column, define a column or multiple columns as filter accelerators. A filter accelerator indicates that the column will be used in subscription queries and requires performance-related handling by

Data Integration Hub

. Use this indicator with topics that you plan to use for unbound subscriptions.

When you use filter accelerators, consider the impact that performance-related handling has on system performance:

Filter accelerators speed up the handling of subscriptions that use both filters and PowerCenter pushdown optimization. By default, the PowerCenter pushdown optimization option is selected for unbound subscriptions only.

Filter accelerators slow down the writing of publication data to the

Data Integration Hub

publication repository.

Filter accelerators have no impact on subscriptions that do not use filters.

In the

Key

column, define a column from a topic table for which to define relations as a primary key.

Define primary keys for as many tables as required, one primary key for each table.

For each table for which you defined a primary key, define one or more foreign keys. A foreign key must relate to a primary key from a different table.

Click

The

Data Retention

page appears.

Creating a Topic with a Relational Database Publication Repository

Creating a Topic with a Hadoop Publication Repository

Creating a Topic with a File Store Publication Repository

Download Guide

Watch

Comments

Communities

Knowledge Base