For example, from the mappings that are created in
Figure 1, you can see that the matching elements do not actually
match in data type. You need to transform the source element (WORKDEPT) so
that it is compatible with the target element (DEPTNUMB):
Figure 1. Adding a transformation
Here is an example of the SQL script
that you can generate from the mapping model after adding the transformation:
SELECT ASCII(S0.WORKDEPT) AS DEPTNUMB,
...
FROM SAMP.EMPLOYEE S0;