Cross Reference Workbook

This workbook is used to control which data is processed for the import, export, delete, and validate operations. It lists the tables exercised in the process.

Structure

A cross reference workbook has worksheets for only those data setup utility operations that it supports. The following sections describe the format of the worksheets for these DSU operations:

import
export
delete
validate

The DSU basically starts at the top and works its way down the list as it executes, except for the delete operation. For export and validate the order of the rows is unimportant, but that is not the case for import and delete. The reason is that tables are related. This can be seen with the use of the complex statement. A table that uses this method expects the related table to have already been populated. The delete operation is governed by the same relationships, so it starts it process from the bottom and works its way up.

The top down order for the import process is to help explain the reasoning behind the importing of the data into the database. But actually it is describing the second phase in a two phase process.

There is a special case when considering the mode options for the import process. To handle the replace mode, the DSU starts at the bottom and works it's way up executing all replaces (which are simply delete entire contents of table actions). This can be thought of as phase 1. In phase 2, the replaces are treated as inserts.