I'm having a stored procedure(SP) executed within Mapping which is taking around 45 mins and the SP has output (Select columns). Based on the operations within SP, output is generated and is used to update value in SQL Server table.
During the SP execution the Informatica Cloud job is failing to keep the connection live.
Is there any way to keep the connection alive? How to do that?
Is there a property KeepAlive/ timeout property for Informatica Cloud Agent?