Tuesday, July 27, 2010

Character Map


Character Map Transformation

The Character Map transformation applies string functions, such as conversion from lowercase to uppercase, to character data. This transformation operates only on column data with a string data type.
You configure the Character Map transformation in the following ways:
  • Specify the columns to convert.
  • Specify the operations to apply to each column.
The Character Map transformation can convert column data in place or add a column to the transformation output and put the converted data in the new column. You can apply different sets of mapping operations to the same input column and put the results in different columns. For example, you can convert the same column to uppercase and lowercase and put the results in two different columns.
Mapping can, under some circumstances, cause data to be truncated. For example, truncation can occur when single-byte characters are mapped to characters with a multibyte representation. The Character Map transformation includes an error output, which can be used to direct truncated data to separate output

Mapping Operations



The following table describes the mapping operations that the Character Map transformation supports.
OperationDescription
Byte reversalReverses byte order.
Full widthMaps half-width characters to full-width characters.
Half widthMaps full-width characters to half-width characters.
HiraganaMaps katakana characters to hiragana characters.
KatakanaMaps hiragana characters to katakana characters.
Linguistic casingApplies linguistic casing instead of the system rules. Linguistic casing refers to functionality provided by the Win32 API for Unicode simple case mapping of Turkic and other locales.
LowercaseConverts characters to lowercase.
Simplified ChineseMaps traditional Chinese characters to simplified Chinese characters.
Traditional ChineseMaps simplified Chinese characters to traditional Chinese characters.
UppercaseConverts characters to uppercase.
Mutually Exclusive Mapping Operations


More than one operation can be performed in a transformation. However, some mapping operations are mutually exclusive. The following table lists restrictions that apply when you use multiple operations on the same column. Operations in the columns Operation A and Operation B are mutually exclusive.
Operation AOperation B
LowercaseUppercase
HiraganaKatakana
Half widthFull width
Traditional ChineseSimplified Chinese
LowercaseHiragana, katakana, half width, full width
UppercaseHiragana, katakana, half width, full width

































Print this post

No comments: