Could you please show the connection screenshot that is being used.
Mask the sensitive information if required.
Requesting this screenshot to verify the connection Type you are using.
And also how much time the same number of record fetch takes outside Informatica?
Please replace the SQL server target with a flatfile target and see if there is any better performance? This is to eliminate the target involvement in the issue.
Hi Mario ,
Could you please share the session log to have a check on the performance issue details.
This will help us in suggesting more.