In the previous post I explained how to enable a Topobase document for import with the Oracle data import tool (here).
In this article you will see how to link domains and their values. In the SIMROSEWATER source schema the material of the pipe is stored in the MATERIAL table. For each of these values there should be a corresponding value in the Topobase domain table WA_MATERIAL_TBD, and if there is no corresponding value, you will have to add it. The Oracle data import allows you to add missing values in the target domain tables.
Open the Oracle data import tool. Select the mapping definition that you created in the previous post, and click Edit. The Edit Mapping Definition window is displayed.
Select the Domains tab. Select MATERIAL under Source Domains for SIMROSEWATER, and select WA_MATERIAL_TBD under Final Domains for ATORAMIG. Click Link Domains.
The icon shows that the tables are linked. The link is listed under Linked Domains.
Now you will map the values of the domain. Select the Domain Values tab.
First, you need to relate the ID and VALUE of the domain table to the primary key and description of the source table (MAT_CODE and MAT_NAME). Click Domain Settings.
Select the MAT_CODE Source Key Column and select the MAT_NAME Source Caption Column. Retain the default values for the target columns (ID and VALUE).
Click Close. The Link Domain Values area displays the values of the MATERIAL table listed by MAT_CODE – MAT_NAME.
Before linking domain values, you need to analyze your data and know which entries you need to create in the Topobase domain table. It is recommended that you copy first the new values to the domain table. Select the new values in the source table and Click Copy.
Now you can use the Autolink functionality to match values automatically in the source and target tables. This process works in three levels:
- The string is exactly the same
- Any of the words in the source string are contained in the target string
- Using the soundex algorithm
Autolink matches the column with the first match in the alphabetically ordered list of target values.
Click Autolink and the values are linked automatically.
Afterwards, you can review the linked values, unlink any incorrect values or link manually values that were not automatically linked. The resulting links should appear as shown in the figure below:
In the next post I will show you how to link feature classes and attributes.
Comments