Insert

Insert operation inserts records from the source table into the target table after applying the mapping.

If you specify the result table it will be created and contain all the records returned by the target source as result of insertion. The result table is useful as it can contain columns that are not present in the source table, for example, generated keys.

Use drag-n-drop to map source tables onto the target tables. Drag-n-drop creates identical mapping but you can type any expression in the Source Column (Expression) column. Such an expression is in the language supported by the source.

Parameters:

• map columns automatically on execution: if checked, the source columns will be automatically mapped to the target columns by exact name comparison. The mapping is done on execution: it iterates through the target columns that exist at the time of execution and tries to match them to the source columns.

• standardize column names: if checked, the column names of the result table will be normalized - converted low case, spaces replaced with “_”.