Subsetting data during registration

Certain advanced techniques are useful when subsetting your data before or after it is captured from a registered source. These techniques are especially useful if you want to capture the same subset of data once and replicate that subset to many target tables.

You can choose to subset data either before or after it is captured from a registered source. The techniques in this section can be used in all replication configurations except update-anywhere or peer-to-peer replication.

Subsetting data during registration can improve replication performance because it reduces the amount of data that the Capture program adds to the CD table and the amount that the Apply program reads. It also reduces storage because there are fewer rows in the CD table.