Page History

...

1. Click the target table from the  Objects  list in the left pane.
   The middle pane displays the properties of the selected target table, the pane is identified as a target for new Source Mapping objects.
2. Browse to the Data Warehouse via the  Browse > Source Table  menu option.
3. Click the source table that contains the columns you want to include as sources from the  Browser  pane and drag it to the middle pane.
4. Click the  Add Source Mapping  button in the  Resolve Table Drag/Drop  prompt.
   
5. The new Source Mapping objects are created and displayed under the target table in the Objects list pane.
   The middle pane displays the Source Mapping tool which provides a graphical representation of the mapped columns between the second source table and the target table. The columns from the source table that exists in the target table are automatically mapped.
   
6. To map the additional source columns that does not exist in the target table, click the connection point of the source column you want to map and drag the line that appears to the connection point of the Add New Column row in the target table.
   
7. Repeat the same steps to map all the other source columns to the target table.
   
8. Click Save Changes to save the defined source mappings.
9. Right-click the target table from the Objects list in the left pane and select Create(ReCreate) from the context menu to recreate the table. The Results pane displays confirmation that the target table was successfully recreated.
   

...