A mapping is ultimately about transforming data from one format or structure into another. In a very basic mapping scenario, you add to the mapping area the components which represent your source and your target data (for example, a source XML schema and a destination one), and then draw visually the mapping connections between the two structure. A connection is, therefore, the visual representation of how data is mapped from a source to a destination.
Components have inputs and outputs which appear on the mapping as small triangles, called connectors. Input connectors are positioned to the left of any item to which you can draw a connection. Output connectors are positioned to the right of any item from which you can draw a connection.
To draw a connection between two items:
•Click the output connector of a source item and drag it to a destination item. When the drop action is allowed, a link tooltip appears next to the text cursor.
An input connector accepts only one incoming connection. If you try to add a second connection to the same input, a message box appears asking if you want to replace the connection with a new one or duplicate the input item. An output connector can have several connections, each to a different input.
To move a connection to a different item:
•Click the stub of the connection (the straight section closer to the target) and drag it to the destination.
To copy a connection to a different item:
•Click the stub of the connection (the straight section closer to the target), and drag it to the destination while holding down the Ctrl key.
To view the item(s) at the other end of a connection:
•Point to the straight section of a connection (close to the input/output connector). A tooltip appears which displays the name(s) of the item(s) at the other end of the connection. If multiple connections have been defined from the same output, then a maximum of ten item names are displayed. In the sample below, the two target items are SinglePrice and value2 of the multiply function.
To change the connection settings, do one of the following:
•On the Connection menu, click Properties (this menu item becomes enabled when you select a connection).
•Double-click the connection.
•Right-click the connection, and then click Properties.
See also Connection Settings.
To delete a connection, do one of the following:
•Click the connection, and then press the Delete key.
•Right-click the connection, and then click Delete.