Join stage: Properties section

Use the Properties section on the Stage tab to specify how the Join stage operates.

The Properties section allows you to specify properties which determine what the stage actually does.

The following table gives a quick reference list of the properties and their attributes. A more detailed description of each property follows.

Table 1. Properties
Category/Property	Values	Default	Mandatory?	Repeats?	Dependent of
Join Keys/Key	Input Column	N/A	Y	Y	N/A
Join Keys/Case Sensitive	True/False	True	N	N	Key
Options/Join stage: Options category	Full Outer/ Inner/Left Outer/ Right Outer	Inner	Y	N	N/A