Sort

This article describes an example of creating and executing an ETL task with source data sorting.

The repository must contain two tables T_Source, T_Destination, tables must be identical in structure and must contains the Value field. Sorting will be executed by the field values. 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 Sorting transformer, 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 | IEtlPlainDataSort