Join

Prev Next

This is the conversion (transform) operation information for the join (column merge) type.

Note

For common syntax and field information on the node source, transform, and target types of Data Flow ETL jobs, see ETLJobNode common.

Syntax

The following describes the syntax.

private String joinType;
private long leftNodeId;
private long rightNodeId;
private List<JoinCondition> joinConditionList;
private String prefix;

Field

The following describes the fields:

Field Type Required Description
joinType String Required Join type
  • INNER | LEFT_OUTER | RIGHT_OUTER | FULL_OUTER
leftNodeId long Required Left node ID
rightNodeId long Required Right node ID
joinConditionList[].leftField String Required Left field
joinConditionList[].rightField String Required Right field
joinConditionList[].joinOperator Operator Required Operator
joinConditionList[].conditionOperator ConditionOperator Required Condition
prefix String Optional Field prefixes to be changed on join