Insert with reference dataset

Function

The Insert with reference dataset operation allows you to insert values on a target dataset based on a source dataset. The transformation of the data is piloted and enriched by the reference datasets (see Reference dataset).

It is possible to set the values of the fields of the reference dataset as condition fields. If a value of a condition field of the reference dataset is not specified, every value in the corresponding field on the target dataset makes the condition true.

This operation does not take account of the management of the level field on the reference and does not involve checks on any rows to be duplicated, regardless of the type of reference dataset.