top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica - Getting multiple records using Teradata stored procedure

0 votes
394 views

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

posted Jun 26, 2014 by Sunil

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

1 Answer

0 votes

You can call the Stored Procedure in Source Qualifier transformation using SQL Query property. Just make sure the ports, their order and datatypes reflect the columns returned by the Stored Procedure.

answer Jun 30, 2014 by Shweta Singh
Similar Questions
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

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

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

...