Edit the table map
You use a table map to direct the placement of data in an insert process. A table map matches the source tables in the archive file to the destination tables in the database. You can also use a table map to exclude tables from the restore process.
In the Insert Request Editor, click to open the Table Map Editor.
The name of the source archive file and the qualifier for tables in the file are displayed. You must provide a destination qualifier to identify the destination tables. To prefix the table names in the table map, enter the dbalias and creatorid that correspond to the sample database tables. A description can be a useful way to identify a table map for reuse. For this scenario, type Map ORDERS and DETAILS.
Tables tab
Using the grid on the Tables tab, you can match source tables in the archive file to destination tables in the database. The Destination Table column is initially populated with names of tables for which Delete Rows after Archive is selected in the access definition used to create the source archive file.
To restore archived rows to the ORDERS and DETAILS tables, verify that the table map pairs:
- Source table ORDERS to destination table ORDERS.
- Source table DETAILS to destination table DETAILS.
To exclude the ITEMS and CUSTOMERS tables from processing, verify that the destination table cells for source tables ITEMS and CUSTOMERS are blank.
When finished, click on the Table Map Editor to return to the Insert Request Editor. Then click on the Insert Request Editor to return to the Restore Request Editor. The Restore Request Editor is displayed with the local insert request listed in the Insert Requests grid.
