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.
- 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.