Complete a mapping by connecting the mapping objects. You connect mapping objects through the ports. Data passes into and out of a transformation through input ports, output ports, and input/output ports.
When you add an object to a mapping, you connect the properties according to how you want the Data Integration Service to transform the data. The editor displays mapping objects in the following ways:
Iconized. Shows an icon of the object with the object name.
The following image shows a mapping with iconized objects:
Normal. Shows the columns and the input and output port indicators. You can connect objects that are in the normal view.
The following image shows the preceding iconized mapping in normal view:
When you link ports between input objects, transformations, mapplets, and output objects, you can create the following types of links:
One to one links. Link one port in an input object to one port in an output object.
One to many links. Link one port to multiple output objects. You can also link multiple ports in one object to multiple output objects.
You can manually link ports or link ports automatically:
Manually linking ports. You can manually link one port or multiple ports. Drag a port from an input object to the port of an output object.
Automatically linking ports. When you link ports automatically, you can link by position or by name.