Using add_subset_rules for Apply
This method is a variation of the
add_table_rules method where DML conditions can be added.
For example, to a particular destination, the goal is to apply
only a specific set of rows based on a WHERE clause type
condition. Based on some attribute within a row, the DBA may
chose to replicate only some subset of the data. This procedure
helps specify the where clause type condition.
Figure 5.4 shows the signature and the
arguments for the add_subset_rules procedure. The
argument dml_condition specifies the where clause type
condition which basically sets the filter condition.
Figure 5.4 add_subset_rules procedure
This will be illustrated by an example. The
example begins with the table named ALLINSURED1 which is
residing in schema NY3. The usual capture and propagation will
be configured at the source database. At the destination
database, the add_subset_rules procedure will be used and
the DBA will specify the DML condition.
The configuration process follows the
Create the queue at the source
database using set_up_queue.
Create the Capture process at
the source database using add_table_rules.
Create the queue at the
destination database using set_up_queue
Create the Apply process using
Create the propagation process