When you create a new Load Request, the Load Request Editor Options dialog and the Load Request Editor open at the same time.
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.
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.
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.
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 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: