Creating an aggregation edge for configuration loading graphs

This task describes how to create an edge to connect a Denormalizer in a load configuration graph to other components in the graph.

To configure an aggregation edge:

  1. Right-click on the Edge and select New metadata > User defined.

    Integrator ETL displays the Metadata editor with one default field.

  2. In the Record:recordName1 field:
    1. Change the recordName1 default value to a descriptive name, such as DenormEdge.
    2. Leave the Type field as delimited.
    3. Set the Delimiter field to the delimiter character in your input file (which is the comma in our example).
  3. Change the field1 name to xmlString and leave its Type as string.
  4. Click the + (plus sign control) to add a new field. Name the field singleAggregationKey and set its Type as integer.
  5. Click Finish.
  6. Save the graph.