Split/Join

Split is used for concurrent execution of tasks. Split requires Join to end of the concurrent execution. Join is used to end split execution. Join task waits until all the split executions finish.

When a flow reaches split component, Split component calculates how many paths are on the right.

Split executes all the components on the right until it meets Join.

This flow is split into two SQL components and joined after those SQL components. Split creates two threads and assigns the SQL components to each thread respectively. Those two SQL queries are executed concurrently and Split waits until all the threads are complete. Once all the threads are complete, Split is complete..