The following describe the process for managing source mappings between the source table(s) and the target table.
- Right click the Source Mapping object from the left-pane and then select Maintain Source Mappings from the context menu.
- Click the connection point of the source column you want to map and then drag the line that appears to the connection point of the target column.
- The target table can be clicked and dragged vertically (up/down) within the diagram view. This is useful when there are more columns in the target table that can fit in the visible area of the diagram view. You can also use the mouse wheel for scrolling up/down the diagram view.
- You can undock any of the panes (Object, Browser and Results pane) in the Builder window, to gain a bigger work area for the Source Mapping tool.
- To map a source column that does not exist in the target table, click the connection point of the source column you want to map and then drag the line that appears to the connection point of the Add New Column row in the target table.
- To remove an existing source mapping, click the connection point from the target table and then drag away the line that appears to disconnect.
Note
- Clicking Remove All removes all the current mappings between the source table and the target table.
- Clicking Hide Mapped Columns hides all the current mappings and only the unmapped columns are displayed. This is useful when there are more columns in the target table that can fit in the visible area of the diagram view and you only want to work on the columns that are not mapped.
- Clicking Auto Map Columns automatically maps all columns from the source table that exists in the target table. This is useful if you removed all or some of the mappings and would like to restore them.