Creating source in Infomrmatica from ...

Creating source in Infomrmatica from the Stored Procedure

Posted in the Informatica Forum

Anna S

New York, NY

#1 Apr 16, 2009
have a stored procedure that returns a resultset. Can I crete a source fromt he resultset of this stored procedure in Informatica? Main goal it to export result of stored procedure to the flat file.
Sharmila Natarajan

Chennai, India

#2 May 12, 2009
Yes. You can get the output of the stored procedure in a file format and use that file as the source in a mapping

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Informatica Admin & Cloud Deployment (May '17) May '17 avi_infa 1
Converting row data to column data (Sep '16) Sep '16 Roopa 1
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
Loading a specific Erwin model version into Met... (Apr '16) Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... (Mar '16) Mar '16 anil 1
More from around the web