We need a feature to stop integrate from failing if number of records impacted by a command is different in source and target locations. For example if command "delete from table1 where pk = value" impacts 1 rows and source and 0 rows on target, integrate should not go down if some integrate option is set. This is required as expired records (older than retention period) on a table may not be sync in our source and target servers. At present, we are handling it with Ignore Error Action, however, that's not right way as error numbers change with versions.

Our targets are Sybase and MSSQL server databases.