Load Request Editor Options Dialog

When you create a new Load Request, the Load Request Editor Options dialog and the Load Request Editor open at the same time.

Load Request Editor Options dialog and Load Request Editor displayed

Server Name

If the optional Optim™ Server is installed on your network, you can delegate resource-intensive Load Request processing (for example, when the source file contains a large number of tables or rows) to a machine hosting Optim Server.

Click the down arrow to select a machine hosting Optim Server, or select Local to process the request on the local workstation.

Note: If the Optim Server machine option is not enabled at your site, the Server Name box is unavailable.

Source File

Enter the name of the Archive or Extract File that contains the data to load. By default, Extract Files have an .xf extension and Archive Files have an .af extension.

Control File

Enter the name of a Control File. This file is used during the process to track the success or failure of preparing each row in the Source File. Control Files have a .cf extension by default.

If you specify a file name that already exists, a dialog prompts you to confirm that you want to overwrite the file when you run the Load Request. (The overwrite confirmation dialog does NOT display when you schedule the Load Request.) To disable this feature, use Personal Options.

Note: If you do not specify the full directory path, the process uses the path defined as the default Data Directory in Personal Options.

You can browse the contents of an Archive, Extract or Control File by clicking Utilities > Browse, or by right-clicking and selecting Browse from the shortcut menu. For details on the Browse Utility, see the Common Elements Manual.

Table Map Options

Specify a Table Map to match source tables in an Archive or Extract File with destination tables or to exclude tables in the Source File from the request. You cannot save or process a Load Request without a valid Table Map.

Within a Table Map, specify a Column Map for any pair of tables to:

Click Tools > Edit Table Map from the Load Request Editor to open the Table Map Editor. For details on how to create, edit, or merge Table Maps, see the Common Elements Manual.

Local
Select this option to create a Table Map to be used only with the active Load Request. Local Table Maps are saved as part of the Load Request.
Named
Select this option to create a new Table Map or select an existing Table Map to be used with the Load Request. You must specify a name for the Table Map you want to create or the name of the existing Table Map you want to use.
Note: If changes have been made to database tables since the last time a Table Map was used, the specifications may no longer be valid, and a warning message displays.
Table Map Name
Name of the new or existing Table Map to use with the Load Request. A Table Map name has two parts: identifier.name.
identifier
Identifier to identify the Table Map (1 to 8 characters).
name
Name of the Table Map (1 to 12 characters).
Always View Table Map
Select this check box to open the Table Map Editor any time you save or run a Load Request. This option provides an opportunity to review the Table Map specifications before you perform the Load Process. If you clear this check box, the Table Map Editor opens only when needed (for instance, when the specified Table Map does not include all the tables in the Source File).