CODEWITHSUNDEEP
transformationinformaticainformatica-powercenter
Dhruuv
Dhruuv

Reputation: 343

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.

Upvotes: 0

Views: 2728

Answers (1)

jrara
jrara

Reputation: 17021

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.

Upvotes: 1

Related Questions