Using add_subset_rules for Apply Creation

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 parameters

 

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 following steps.

1. Create the queue at the source database using set_up_queue.
    

2. Create the Capture process at the source database using add_table_rules.
    

3. Create the queue at the destination database using set_up_queue
    

4. Create the Apply process using add_subset_rules.
    

5. Create the propagation process using add_table_propagation_rules.