In order to apply a filter directly on a source table, a Passthru filter needs to be used. To do so, 'CTRL' click on the table settings for the table on which the filter is to be applied on. The table settings window will open, and under the Filter section, there should now be a new field titled 'Fullload Passthru Filter' in which a filter can be entered. Note: The filter syntax must match the syntax of the source database.
If the following error appears after saving the filter and running the task: "Table 'x' cannot be reloaded because a passthrough filter is defined for it.....", then you will need to add the following line into <Replicate Installation Directory>\Attunity\Replicate\bin\repctl.cfg
"enable_passthrough_filter": true