The Case Converter transformation is a passive transformation that standardizes the case of the alphabetic characters in input strings.
You can select a case conversion format, such as uppercase, lowercase, title case, and sentence case. You can also reverse the current case of each character in the input data.
The Case Converter transformation can use the values in the Valid column of a reference table to define the case of the input characters. When the transformation finds a match between an input value and a valid value, the transformation applies the case of the valid value to the input value. You can use reference tables when the case conversion type is
Title Case
or
Sentence case
.
You can create multiple case conversion strategies in a Case Converter transformation. Each strategy uses a single conversion type.