Use the Load tab to customize loader parameters and enforce loader requirements for your site. This can be particularly helpful when you have more than one database, or more than one Optim™ Directory. You can specify default parameters applicable to all defined DB Aliases, and as needed, specify unique parameters for each different database, each instance or version of a database, or each different Optim Directory.
For example, after selecting an Optim Directory, you can select [Default] in the DB Alias box. Loader settings you define will apply to all DB Aliases in the selected Optim Directory. If the default settings are not appropriate for one DB Alias, you can select that DB Alias in the DB Alias box, select the Override default settings check box, and define specific settings for that DB Alias only. You can repeat the procedure for any or all DB Aliases in the selected Optim Directory, and similarly, for all DB Aliases in each Optim Directory.

Select the name of the Optim Directory containing the DB Aliases for which you want to customize loader parameters. If your site has more than one Optim Directory, and you want to specify loader parameters for DB Aliases contained in those directories, click the down arrow to select from a list.
Click the down arrow to select from the available DB Aliases in the selected Optim Directory. If you select [Default], the custom loader parameters you specify apply to all DB Aliases in the selected Optim Directory.
Select to define unique loader parameters for a specific DB Alias, when default values are defined for all DB Aliases in a selected Optim Directory.
This check box is applicable to SQL Server and Sybase ASE DB Aliases only. When Replace is specified in a Load Request, data loaded to the affected tables is truncated, unless the particular table is partitioned, in which case the truncate action will fail. Select this check box to issue the SQL Delete statement when the SQL Truncate statement fails.