top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
602 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

0 votes

I have to import a stored procedure from Oracle database into Informatica. But when I try to use the Stored Procedure Transformation I cannot view the respective stored procedure. I am using the correct oracle driver since I don't have any trouble in importing target database tables. I tried viewing the stored procedures in the oracle database using select * from all_objects where object_type='FUNCTION' but could not find the function I am looking for. Please advise me on these:

• Can we view the list and code of Stored procedure(s)/function(s) in Oracle

• What am I missing in Informatica stored procedure transformation?

...