I am about to automate some weekly activities for the team using Boomi.
However, the process involves firing 50 different queries to get o/p of each.
These are GreenPlum queries. GreenPlum doesnt support stored procedures.
I am splitting the queries across multiple processes.
What is the best way to fire so many queries w/o affecting the performance.
It is not really possible to combine the queries.