Union

To add an input:

1. Click the Add button. The Input Properties dialog box opens:

2. Determine unique identifier of the input in the Identifier box.

3. In the Link to Object drop-down list select the consumer, which output sends data to created object transformer.
   After object selection it is prompted to fill in the list of fields from the linked output.

The input and its link with the object are created.

To edit input:

1. Select the required input.

2. Click the Edit button. The Input Properties dialog box opens:

3. If required, edit identifier.

4. If required, in the Link to Object drop-down list select or change the consumer, from which output data is loaded to the created object transformer. After the user has selected or changed the object, it is prompted to fill in the list of fields from the linked output.

Input and its link with object are changed.

Duplication enables the user to create an input with fields of previously created input.

To duplicate input:

1. Select the existing input.

2. Click the Duplicate button. The Input Properties dialog box opens:

An input with fields of previously created input is created.

To delete input:

1. Select the required input.

2. Click the Delete button.

The input is deleted without showing confirmation dialog box.

To create a field:

1. Select the required input. The provider or consumer fields are displayed at the bottom of the dialog box.

2. Add a field to the list:

• Click the Add button.

• The INSERT key.

• Double-click a free area.

The dialog box opens:

3. Edit identifier and name. They are equal by default.

4. Select the required field type in the drop-down list, depending on the provider or consumer data type.

The field with specified parameters is created.

To edit the field:

1. Select the required input. The provider or consumer fields are displayed at the bottom of the dialog box.

2. Select the required field or fields in the list.

NOTE. Multiple field selection is available using the CTRL+A key combination or holding down the CTRL key.

3. Click the Edit button. The dialog box opens:

4. If required, edit identifier and name. It is not available to edit identifier and name on multiple field selection.

5. If required, change type of field or fields in the drop-down list.

Parameters of field or fields are changed.

To delete a field:

1. Select the required input. The provider or consumer fields are displayed at the bottom of the dialog box.

2. Select the required field or fields in the list.

NOTE. Multiple field selection is available using the CTRL+A key combination or holding down the CTRL key.

3. Click the Delete button.

Field (fields) is (are) removed without showing confirmation dialog box.

To autofill fields:

1. Select the required input.

2. Select one of the Fill From button items:

• From Provider. Fields from data provider are added to the list.

• From Consumer. Fields from data consumer are added to the list.

Data provider or consumer fields are added to the list.

This field contains a list of all outputs from transformer linked to data consumer objects.

To edit output:

1. Select the required output in the list.

2. Click the Edit button. The Output Properties dialog box opens:

3. Edit identifier.

4. Use the Link to Object drop-down list to select or change the consumer object, to input of which data from transformer object is loaded.
   After selecting or changing the object, it is prompted to fill in the list of fields from the linked input.

After executing the operations, the output from the consumer object and/or its link to the transformer is changed.

Fields of consumer object, to which data is to be loaded, are used to determine the format of data output. The list of fields is filled in automatically when setting up a link to the consumer object.

To determine advanced settings to be applied when there are error records, execute the following operations:

1. Click the Settings button. The dialog box with the same name opens:

2. Determine settings:

• Maximum Number of Records in the Error Output. Specify the maximum number of error records, information about which is exported. The -1 value is set by default, in this case information about all error records is exported.

NOTE. If there is a number of error records, information export may slow down ETL task execution.

• Action Executed on Exceeding the Maximum Number of Error Records. Select the action in the drop-down list, which is executed if the maximum number of error records is exceeded:

• Stop Task Calculation. If the maximum number of error records is exceeded, task calculation is stopped.

• Stop Outputting Records. Default value. If the maximum number of error records is exceeded, record output is stopped.

After executing the operations, the settings will be determined that will be applied when there are error records.