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.
Can you guys help here?
Usually the culprit is that the DB connection used in PowerCenter(?) uses different credentials than the user ID which you use for the respective DB client tool. For example, you might access that source DB using TOAD with your own user ID, but PowerCenter(?) uses some technical user ID, not your user ID.
Could you please double-check that?