NLS locale tab

It lets you view the current default collate convention, and select a different one for the stage if required. You can also use a job parameter to specify the locale, or browse for a file that defines custom collate rules. The collate convention defines the order in which characters are collated, for example, the character Ä follows A in Germany, but follows Z in Sweden.

Select a locale from the list, or click the arrow button next to the list to use a job parameter or browse for a collate file.

The following types of stages have an NLS Locale tab:

• Stages that evaluate expressions, such as the Transformer.
• Stages that need to evaluate the order of key columns.
• The Sort Stage.