I am trying to balance a query using a SQL Inbound Adapter against the output of Ensemble. I am finding that a couple of records here and there are missing in the output file.
Most of our queries are based of of views which may or may not have a unique key.
So If you don't have a Delete Query in your settings and Key Field Name is blank, it is possible that some records may or may not make it through to your endpoint?
Integration - Interfaces
The Ohio State University Wexner Medical Center