You can make a more precise selection of the source data. You do this by selecting the source tables to be merged (for example, Manufacturers Table, Status Table, I/O Table, and so forth) in the Advanced Selection dialog.
You open the Advanced Selection dialog by selecting Advanced in the Select Items dialog.
The Advanced Selection dialog consists of the following sections:
-
Filter: Select the criteria that are used to filter the displayed tables.
-
Sort: Select whether to sort the tables by name or by merge order.
-
(Table data): Select the required source table to transfer to the target domain. You can also type additional data to append to the target domain during the transfer process.
If you resume a previous merge session, you see in the Advanced Selection dialog the source tables which were selected in that merge session.
Now you can:
-
Select the source tables that you want to merge.
-
Specify data that will be appended to the target domain during the data transfer.
-
Specify an insertion condition for the required source tables.
-
View the displayed source tables according to your required filtering and sorting options.
-
Do one of the following:
-
Under the Select column, select the check box for each table you require to include in the merge process.
-
Select the Select all check box to select all the available source tables.
-
Selected source tables are displayed in red; unselected source tables are displayed in black.
-
To locate a table by name, select Search and type the table name in the text box.
-
-
Select the check box in the Insert Only column if you want to specify an insertion condition for the selected table — any updated data in the table does not get merged in this case.
-
To merge the reference tables of any selected source table, select Reference Tables.
All the reference tables associated with the selected source table are automatically
selected for merging.