Split

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

The repository must contain three tables: T_Source, T_DestinationOne and T_DestinationTwo. Tables must be identical in structure, there is a field with the ID identifier, records are split by values of this field. The repository must also contain an ETL task with the ETLTASKS identifier. On executing the example presented below four objects are created in the ETL task: repository source, the Split transformer and two repository consumers. The required properties are defined for all objects, links are set, split conditions and linking of consumers for each condition are set:

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 | IEtlPlainDataSplit