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 and Load Request Editor Options dialog. The elements of the Load Request Editor Options dialog are described as follows.

Server Name

If the Optim™ Server is licensed and installed, you can direct resource-intensive Load Processing (for example, when the source file contains a large number of tables or rows) to a machine hosting the 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 option is not enabled at your site, Server Name is unavailable.

Source File

The name of an Archive or Extract File used as the basis for the Load Request. This file provides the data model for a Table Map created from within the Load Request and, unless overridden, the data to be loaded.

Control File

The name of a Control File, used to track the success or failure of processing each row in the Source File. The .cf extension is added by default. If you do not provide a path with file names, the default Data Directory defined in Personal Options is used.

If you enter the name of an existing Control File, a dialog prompts to confirm that you want to overwrite the file when you run the Load Request. To disable the confirmation prompt, use Personal Options.

Note: You can browse the contents of a Source or Control File by clicking Utilities > Browse or by right‑clicking and selecting Browse from the shortcut menu. For details on the Browse Utility, refer to the Common Elements Manual .

Table Map Options

A Table Map used to match data in the Source File to destination tables or to exclude data from selected tables from processing. A Load Request must reference a valid Table Map in order to be saved or processed. Click Tools > Edit Table Map from the menu to display the Table Map referenced for Load processing. For details on how to create, edit, or merge Table Maps, refer to the Common Elements Manual .

A Table Map may reference a Column Map for any pair of tables to:

Local
Embed a Table Map in the Load Request. Local Table Maps are saved as part of the Load Request and can only be used with it.
Named
Create or select a Table Map to use with the Load Request. You must provide a name for the Table Map. (If the database structure has changed since the Table Map was last used, a warning is displayed.)
Table Map Name
The Table Map used for Load processing.
identifier
Identifier (1 to 8 characters) for the Table Map.
name
Name of the Table Map (1 to 12 characters).
Always View Table Map
Display the Table Map each time you save or run the Load Request. Clear this check box to display the Table Map only when necessary (for example, when the Table Map data structure does not match that of the Source File data).