Chapter 4 Working with an XML model
You can map elements to PDM objects.
Once the tables are identified and mapped with the elements, you can define mappings between columns and attributes.
But columns can also be mapped to elements. Mapping a column either to an attribute or an element depends on the schema presentation:
Case 1:
A column should be mapped to the name attribute.
Case 2:
A column should be mapped to the name element.
You have to use the Mapping tab of an element property sheet to define element mappings. It contains the following sub-tabs:
The Element Sources sub-tab allows you to associate one or several tables in the data source to the current element.
You can use the Add Objects tool to select tables from the PDMs open in the current workspace.
For more information about the Add Objects tool, see the "Mapping Editor" chapter in the General Features Guide.
The Attributes Mapping sub-tab allows you to define the mapping between columns in the source tables and attributes in the current element.
For more information about the different tools in the toolbar, see the "Mapping Editor" chapter in the General Features Guide.
The Criteria sub-tab allows you to specify join criteria between source tables. For example: EMPLOYEE.ID < 100
The Select sub-tab displays the entire SQL statement used to select data in the data source. This statement is automatically generated.
If you modify it, the statement is no longer calculated and the User Defined tool is pressed in the toolbar. You can recover the automatically generated statement by clicking the User-Defined tool, this will automatically remove any non calculated expression in the tab.
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |