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