User`s guide

Transformation components
100 Sybase IQ ETL 4.1
❖ To set up required properties
1 Add the component to the project and connect the ports of the component
to adjacent components.
2 Open the Mapping window by clicking Mapping in the Properties section.
3 Enter at least one mapping.
The Character Mapper component is designed to visualize the result of a
character mapping immediately after the mapping has been entered. To switch
of this kind of automatic synchronization, click Auto Synchronization.
❖ To add a character mapping
1 Click Add Line in the toolbar.
2 Enter a character or string in the From columns.
3 Enter a character or string in the To column. If you do not enter a value,
the From value will be effectively removed without any replacement.
To delete a character mapping, select the line and click the Remove Line
button.
To save the current mapping to a file, click the Save File button.
To open a mapping from a file, click the Open File button.
Optional properties
In the Properties section, you can select the attributes to use the character
mapping previously defined. By default the mapping rules will be applied to all
attributes of the incoming data.
To customize the default setting, click Exclude and then select the attributes
that you want to exclude from the mapping.
Example values for a character mapping are:
From To Description
Ä ae Umlaut character mapping.
customer kunde String replacing.
<13><10> (ASCII decimal)
Delete CR LF at the end of the line.
<xD><xA> (ASCII hexadecimal)
Delete CR LF at the end of the line.