Group

This article describes example of creating and executing an ETL task with aggregation of duplicate value by specified field at the output.

The repository must contain two tables: T_Source and T_Destination. Tables must be identical in structure, the field with the ID identifier is present, this field is used to search for duplicate records. The repository must also contain an ETL task with the ETLTASKS identifier. On executing the example presented below three objects are created in the ETL task: repository source, the Group converter and repository consumer. The required properties and links are set for all objects:

After objects are created and saved, the ETL task is executed. The similar code applied to different objects is placed into separate procedures or functions.

Example

See also:

Examples | IEtlPlainDataGroup