I have process which fetches the data from DB and convert it to XML. The volume expected to process is around 80 million. I have used the batch count as 1 in DB connector and grouped the data based on the element STORENUMBER. So now the DB connector will group the data as a document for each Stores(80 stores). After this i have used flow control with "No document batching" and 10 threads. Data s in single document for single store is interdependent (4 rows of record will form a single output in mapping) due to this i have not used "Run as batches option". Even after the use of flow control, the processing time is very high because of high volume of records in each thread. I would like to know whether we can use one more flow control after mapping to reduce the processing time?
New flow control added process:
Is this is good approach to use two flow control for same process?