1. Using the Oracle Mapper with Oracle Integration Generation 2
  2. Map Data
  3. Repeat a Target Element to Map to Different Sources

Repeat a Target Element to Map to Different Sources

You can repeat a target element in the mapper. This enables you to map different sources to the same target element. Elements defined in the target schema with the maxOccurs attribute set to a value greater than one can be repeated.

To repeat a target element to map to different sources:
  1. In the target data structure, right-click the element node to repeat, and select Repeat Node. This option is only available on elements that you can repeat. Elements that can be repeated are identified by a special icon with two bars to the left of the name. When you place your cursor over these elements, the words Repeating: true are displayed in the information text.
    Description of jet_mapper_repeat.png follows
    Description of the illustration jet_mapper_repeat.png

    The element is repeated and displayed below the existing element. Elements that are repeated show the count (for example, 1 of 2 for the existing element and 2 of 2 for the repeated element. You can repeat an element multiple times.

  2. Expand the existing and repeated elements to see that the attributes in each element are repeated.
  3. Drag appropriate source mappings to the repeated targets.

    Note:

    If you create a repeatable element in which you do not do any mapping, click Close, and apply your changes when prompted, the empty element is not saved.