About
In order to improve performance, specifically on full-load operations, another variant is to reduce the amount of data to be transferred.
This can either happen by selecting or excluding specific columns, which is common practice, or in theory also by filtering the data on a record level, in order to replicate only a subset of the data into the target database. While the latter is less-common practice, it is certainly in reach for adding relevant parameters (filtering constraints) to the machinery, if the use case is applicable for that variant.
About
In order to improve performance, specifically on full-load operations, another variant is to reduce the amount of data to be transferred.
This can either happen by selecting or excluding specific columns, which is common practice, or in theory also by filtering the data on a record level, in order to replicate only a subset of the data into the target database. While the latter is less-common practice, it is certainly in reach for adding relevant parameters (filtering constraints) to the machinery, if the use case is applicable for that variant.