I have a mapping where I am calling a stored proc from SQ sql override.
The stored proc is simple having a select query only.
The SQ is having all the fields which are defined in the select query of the stored proc. There is no other filter/transformations.
When the mapping is run, the stored proc outputs only 442 records(out of 446). There is no mention of dropped/rejected records in session log. But when I run the same procedure in DB, it gives all 446 records. The interesting part, the dropped records are every 101th record.