DataFlux Data Management Studio 2.7: User Guide

Branch Node

You can add a Branch node to a data job to enable up to 32 Expression nodes to simultaneously access data from a single source. Depending on configuration, you can either pass the data from the Branch node directly to each of the Expression nodes or temporarily store the data in memory or disk caches, before passing it along.

Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

Memory Cache Size - Specifies the amount of memory (in Megabytes) allocated to this step.

Land all data locally before processing continues - When checked, ensures that all data from the data sources is placed on the local machine before the job continues to be processed. (Selecting this option can reduce the overall job performance.) This option can be useful when the data that is pulled into the Branch node is getting new rows inserted by one or more nodes after the Branch node. In such a case, you might want the Branch node to pull down all currently available rows before the nodes after the Branch node start running through the available data and add more rows to the source table. This situation can create a never-ending job in which the Branch node never reaches the end of rows in the source table because the nodes after the Branch node continue to add rows to that table.

You can access the following advanced properties by right-clicking the Branch node:

• CHUNKSIZE
• DELAYMEMALLOC
• LOADALL