Mapping Models

The logical models are mapped to one or more physical data models. The mapped physical model is used to populate entities of the logical model. You can map models 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 using these two methods:
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.
Note: 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.