Connector Improvement: Ignore Row Count Validation
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.
-
Hi Ankur,
Option Integrate Resilient is designed for what you want. You can have the integrate generate a warning when there is a resilient situation, but if you expect this you may also choose to be silent about it.
Note: I recommend you use WARNING just so you can trace when resilient operations have occurred.
https://fivetran.com/docs/hvr6/action-reference/integrate#resilient
Hope this helps.
Mark.
Please sign in to leave a comment.
Comments
1 comment