I am new learner in Informatica cloud data integration. Currently I am trying to convert SSIS ETL to Informatica.
While conversion, at one point I need to call a SQL Server stored procedure inside Informatica data integration which mainly update some data in tables. I tried many things but not getting success.
Can anyone have any idea how we can call a SQL Server stored procedure using informatica cloud data integration?
Please use the SQL transformation.
refer to the following link : network.informatica.com/videos/1213
Accept this as the right answer if it helped you. This will help people in future