Various Branch and Merge Node Conditions - Teradata Analytic Apps - Vantage Analyst

The Merge node condition option specifies if all executed branches must succeed when you execute the workflow (check or clear this option).

Base Scenario: Branch Node Executes All Conditions; Merge Node Indicates All Executed Branches Must Succeed

Path A includes a failing node followed by a second node; Path B includes success node. A single node follows the Merge node.

Branch Node Implements Workflow-Level Variables for Paths A and B, Execute All True Conditions

• The workflow-level variable value in Path A is equal to 1, meaning it will execute its path.
• The workflow-level variable value in Path B is equal to 0, meaning it will not execute.

Branch Node Implements Workflow-Level Variables for Paths A and B, Execute All True Conditions; Merge Node Setting is Cleared

Because the Merge node setting (All executed branches must succeed) is not set, the workflow is successful even though the failing node fails because the alternate path can be executed. The node after the Merge node also succeeds.

Failing Node Implements Explicit Error Path, All Executed Branches Must Succeed

Specifying an error path to go to the Merge node means action is being taken to manage that error. The path drawn from the failing node to the Merge node means treat this as a success.

When the All executed branches must succeed setting is checked on the Merge node, the failing node is going to be considered a success.

Failing Node Points to Another Node

The failing node points to another node; action is taken based on the error but it still fails and terminates the workflow. A path is drawn from the failing node to another node but the path still succeeds. The node pointed to can be a SQL node or email notification or a rule that converts to log file or table. The failing node error path node points to the End failure node.

The alternate path can still be executed. Anything that executes at a point when the End failure is achieved needs to be canceled.

Workflow execution shows that the alternate path was canceled and the node after the merge is skipped.

Handling an Error and Continuing Execution

A failing node's error path points to another node that handles the error and continue execution and get evaluated by the Merge node.