Chapter 6 Working with PDMs


Mapping tables

The table mapping allows you to identify the physical data objects (tables or views) used to populate data warehouse tables.

Once the source tables or views are identified and mapped with the tables of the current model, you can define mappings between columns.

You have to use the Mapping tab of a table property sheet to define table mappings. It contains the following sub-tabs:

Table Sources sub-tab

The Table Sources sub-tab allows you to associate one or several tables or views in the data source to the current table. Operational data from the source tables will be transferred to the current table.

You can use the Add Objects tool to select tables or views from the physical data models open in the current workspace.

For more information about the Add Objects tool, see the "Mapping Editor" chapter in the General Features Guide.

Columns Mapping sub-tab

The Columns Mapping sub-tab allows you to define the mapping between columns in the source tables or views and the current columns.

For more information about the different tools in the toolbar, see the "Mapping Editor" chapter in the General Features Guide.

Criteria sub-tab

The Criteria sub-tab allows you to specify join criteria between source tables. For example: EMPLOYEE.ID < 100

Select sub-tab

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) 2005. Sybase Inc. All rights reserved.