The semantic mapping tool can automatically detect child semantic links by name at any level from the database schema to tables and columns based on the physical name matching.
This method is not the equivalent of the bulk mapping for data mapping. In a semantic mapping, the detection mechanism is used to generate links at schema, table and column levels at the time you are editing the mapping. If a new table or column is created, you have to edit the semantic mapping again and perform the detection in the UI.
Before you begin
- Go to .
- Select an existing semantic mapping or create a new one from the data model to the database.
- Open the semantic mapping.
- Go to the Mapping Editor tab.
- Navigate to a schema in the source model and the target one.
- Drag and drop the schema from the source to the target.
- Click YES to perform the detection of the child links.
Specify the matching options.
The case sensitivity for the name matching is enabled by default.You can add prefixes or suffixes to be ignored during the matching process.
Click Detect links.
A message displays with the amount of new child links added automatically.
- Click OK.
- Right-click a table on the side of the target model and select Show Object Definitions to verify that the auto detection of the child semantic links succeeded.