|
You can define correspondence between the source and destination (target) fields also known as mapping.
The program automates this procedure using fields with the same names. Also, you can change the default mapping by
using the "Map" and "Unmap" buttons.
To unmap some correspondence select it and click "Unmap". To map select one field in the source table and one
field in the target table then click "Map".

Also, the mapping dialog box allows you to describe additional conversions for the source data during
the migration or import process.
You can specify a function for column conversion. To do it, enter the name of the function or an expression
in the 'Conversion expression' field. If you use the name of a function, you will get an expression of
the following type: FUN(column). You should use the %s marker to specify the position of the parameter
for an expression, e.g. SUBSTR(%s,1,5).
You can specify the explicit conversion of types to the Integer or Float value. It makes sense when you
need to remove non-significant zeros, etc.
|