top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What are the types of data that passes between informatica server and stored procedure?

+1 vote
104 views
What are the types of data that passes between informatica server and stored procedure?
posted Jan 22, 2016 by Sathyasree

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

1 Answer

0 votes

Three types of data passes between the informatica server and stored procedure.
1. Input/Output parameters
2. Return Values
3. Status code.

answer Jan 22, 2016 by Manikandan J
Similar Questions
+1 vote

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

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??

0 votes

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

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...