Is it possible to execute an SP against every row of a component's result output, particularly in parallel fashion?
The most easiest way is to use a tFlowtoIterate to send the records in an iterative fashion to the SP.
The second way is to call the SP from a Talend routine and you can call the routine as a function call from tMap or tjava. But in this case, you are simultaneously doing lot of DB connections (or same connection but shared simlutanous resources).
But from throughput perspective, the best way to process data in especially in parallel fashion is to send the incoming data to a temp table. Then join the data in this table to all other necessary tables with SP and do the processing you want to do. In this method, you need to make one DB call instead of multiple calls and your DBAs also will be happy.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)
Watch the recorded webinar!
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables
Take a look at this video about Talend Integration with Databricks
Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>