Mapping Models

The logical models must be mapped to one or more physical data models to define the data sources to use to populate the entities in the logical model. This mapping can be done using one or a combination of these ways:

• Directly: Drag a table from the physical model to the canvas and establish a link between the columns of the physical and logical tables.
• Transformation: Transform the values before populating it to the logical model tables. The transformation can be application of a conversion function or functions of string numeric, and datetime to a logical model column. It may also involve applying a constant value to a column of a logical model table.

You can filter the data to be populated in the logical model entities:

• Building Criteria: Define a criteria for filtering the data retrieved from the physical model columns. The filtered data is fed to the logical model.
• Joining columns and tables: Combine data from columns of two or more physical model tables before it is populated in the logical model columns.

If you map columns of two different data types, the data type of the logical model column gets updated to that of the physical model column.