AnsweredAssumed Answered

Best way to design process with multiple DB queries (select queries)

Question asked by toral on Jan 3, 2018
Latest reply on Jan 3, 2018 by rakesh.dulam491832

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.

Outcomes