task, you can optionally define table selection rules to select a subset of the source tables in the specified schema. This simple example demonstrates how to use selection rules to select the tables you want.
Assume that 4,071 tables are in the source schema. You want to exclude the tables from which you do not need to replicate data.
Define the following rules in the order shown:
The rules are processed from top to bottom.
Rule 1 includes all source tables in the schema.
Rule 2 excludes the source tables that have names beginning with "SYS".
Rule 3 excludes source tables that include "TGT" anywhere in their names.
Rule 4 excludes source tables that have names ending with "TEST".
After clicking the Refresh icon, the
Total Tables Selected
field shows 3057, which indicates you filtered out 1,014 tables.
ASK INFAPreview
