I have a Data Integration which imports products (and groups) from views to the DW tables (from a Dynamicweb Provider With Views to a Dynamicweb Provider).
The views are the main source, so I basically want to discard anything in the desination that's not in the source; looking at the available options, I figured I could use the option Remove missing rows after import to do so. But nothing that I've tried actually deleted anything in the destination.
I tried setting the option in the desintation setting, and also tried to set it on the specific table settings.
Also I tried to limit the primary key fields to just the product id (which is unique in our case).