Chapter 6 Working with PDMs

Creating a relational to relational mapping for a table

To create a relational to relational mapping for a table:

1. Double-click a table to display its property sheet, then click the Mapping tab.
2. Click the Create Mapping tool beside the Mapping list to create a mapping for the current table. If several data sources are available, you have to select one or several data sources in the selection list and click OK.
3. In the Table Sources sub-tab, click the Add Objects tool to select the source tables you want to map to the current table and click OK.
   
   The name and code of the tables appear in the list.
   
4. Select the Columns Mapping sub-tab and click the Add Mapping tool in the toolbar.
5. Select the columns that will be mapped to columns in the source tables or views and click OK.
   
   The selected columns appear in the first column of the list.
   
   
      Generate mapping
   You can click the Generate Mapping tool to automatically create the mapping between columns with identical name or code in the data source and the current model
   
   
6. Click the down arrow in the "Mapped to" column to select the column in the data source table to which the selected column will be mapped.
   
   You have to repeat this operation for each column you want to map to the data source.
   
7. Select the Criteria sub-tab if you want to specify join criteria between the source tables or views.
8. Select the Select sub-tab if you want to visualize or modify the entire statement.
9. Click OK.

Copyright (C) 2005. Sybase Inc. All rights reserved.