Mapping by Browsing Models
Use this option to browse through the tables and columns in the physical models and discovered connections to find out the right match for your entity attributes.
You can also convert the values from the tables and columns of the physical model before mapping it. You can perform these conversions:
- Transformation
- Use this to transform the values before populating it to the logical
model tables. It includes these types:
- Column transformation: Derive the value from a physical model table column. For more information, see Applying Column Transformation.
- Constant transformation: Define the resulting value as a constant. For more information, see Applying Constant Transformation.
- Function transformation: Define the resulting value using String, Numeric, Conversion, and Datetime functions. For more information, see Applying Function Transformation.
- Building Criteria
- Use this to filter the data retrieved from a physical model column or columns. You can define various filtering criteria.
- Joining columns and tables
- This function combines data from columns of two or more physical model tables before feeding it to the logical model columns.