Informatica - Getting multiple records using Teradata stored procedure -

Informatica - Getting multiple records using Teradata stored procedure -

i trying resultset teradata stored procedure mapping.

the stored procedure hold multiple select statements , final output sent informatica. below sample of how select statement looks

sel 'inh1' qc_code,count(*) table 1 union sel 'inh2' qc_code,count(*) table 2 union sel 'inh3' qc_code,count(*) table 3

i need stored procedure can send output of above query (2 columns, 3 records) informatica, can phone call stored procedure in source qualifier or through sp transformation

any help??

you can phone call stored procedure in source qualifier transformation using sql query property. create sure ports, order , datatypes reflect columns returned stored procedure.

stored-procedures teradata informatica