Search code examples
transformationinformaticainformatica-powercenter

Informatica Stored Procedure Transformation


Is there a way to call a stored procedure transformation which has no input and output parameters defined in the stored procedure? Please advise.


Solution

  • I think the easiest way is to create a dummy mapping (first create a dummy table in the source which has columns for different data types) and then call the stored procedure in the pre-sql or post-sql for the session.