Limiting maximum number of threads when running extract and load in parallel

It is possible to execute multiple source-to-destination transformations (extract-load) in parallel threads.

By default, Etlworks integrator creates as many threads as there are parallel transformations. In some cases, it makes sense to limit the maximum number of threads, for example, to reduce the CPU utilization or to not exceed the API quote.

Step 1.  Create a flow with parallel transformations.

Step 2.  Create a nested flow and add a flow, created in step 1.

Step 3. Add a flow parameter MAX_THREADS and set it's value to the maximum number of threads.