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 “_”.

• Target -> Write mode: defines the method used to write the data:

  • bulk: uses the target connector’s native bulk method. The connector must support this method for the selected operation; otherwise, the operation fails. For Insert into Enterworks, if you specify a Result table, you must also specify the Result key column. This must be a single existing column of the target table, mapped in Column mapping from a source column or expression that produces unique, non-empty values. These values must not already exist in the target repository. After the import completes successfully, this column is used to retrieve the inserted records, including their generated IDs, and match them to the source records.
  • by record: uses the connector’s standard record-based method, which may group records into batches.