Operator Guide

Back Next

Topic Table Relations Properties

The

Table Relations

page of the topic wizard includes the following properties:

Table Name: Name of the table.
Column table: Name of the column.
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.
Key: Assign primary and foreign keys to define relations between topic tables, to filter the data that automatic database subscriptions consume from the topic.
Define columns as 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 columns as foreign keys. A foreign key must be related to a primary key in a different table.