top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Using mapping parameter in an Informatica stored procedure call

0 votes
944 views

I am using a stored procedure as a source in my Informatica mapping, and I have defined the SQL query in the source qualifier as

exec dbo.GET_ATTRIBUTES($$fromDate, $$toDate)

where $$fromDate and $$toDate are mapping parameters I have defined in a parameter file. I have tried a number of different ways of going about this and none seem to work, as the SQL query fails to validate.

So, my question boils down to this, is there a way to call a stored procedure while passing in two mapping parameters?

Thanks in advance

posted Jun 23, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

when you have defined the mapping parameters you have set the IsExprVar field to TRUE. When you set it to FALSE you will be able to pass the parameters to the stored procedure when calling it in the SQL query field of the source qualifier.

answer Jun 26, 2014 by Shweta Singh
Similar Questions
+1 vote
Can I set a Parameter based on the output of a Stored Procedure in Informatica PowerCenter?

In Informatica's PowerCenter, is it possible to set a parameter's value based on the output of a stored procedure? The parameter I want to set is a parameter I defined in a flat-file data object.

0 votes
Informatica - Getting multiple records using Teradata stored procedure

I am trying to get a resultset from Teradata stored Procedure to my Mapping.

The stored procedure is to hold multiple select statements and the final output is to be sent to informatica. Below is a sample of how the select statement looks like

sel 'INH1' AS QC_CODE,count(*) from Table 1 
UNION
sel 'INH2' AS QC_CODE,count(*) from Table 2   
UNION
sel 'INH3' AS QC_CODE,count(*) from table 3

I need a stored procedure that can send the output of the above query (2 columns, 3 records) to Informatica, where I can call the stored procedure in my source qualifier or through SP transformation

Any help??

...