Case Converter Transformation in informatica

The Case converter transformation is a passive transformation used to format the data to similar character formats. Case converter transformation is used to maintain data quality.

The predefined case conversion types are uppercase, lowercase, toggle case, title case and sentence case.

Reference tables can also be used to control the case conversion. Use the "Valid" column in the reference table to change the case of input strings. Use reference tables only when the case conversion type is "title case or sentence case".

Case Strategy Properties:

You can create multiple case conversion strategies. Each strategy uses a single conversion type. Configure the following properties on the strategies view in the case converter transformation:

Reference Tables: used to apply the capitalization format specified by a reference table. Reference tables work only if the case conversion option is title case or sentence case. If a reference table match occurs at the start of a string, the next character in that string changes to uppercase. For example, if the input string is vieditor and the reference table has an entry for Vi, the output string is ViEditor.

Conversion Types: The conversion types are uppercase, lowercase, toggle case, title case and sentence case. The default conversion type is uppercase.

Leave uppercase words unchanged: Overrides the chosen capitalization for uppercase strings.

Delimiters: Specifies how capitalization functions work for title case conversion. For example, choose a colon as a delimiter to transform "james:bond" to "James:Bond". The default delimiter is the space character.

For more Visit  http://www.quontrasolutions.com/blog/category/informatica/