Next >> << Prev  

13.5. Settings: Load

This settings page is where you configure all settings related to export groups and jobs. They are valid for all load groups and jobs and most of them can be overwritten individually at group or job level.

Settings Tab

Validation Level: Load groups and jobs are validated either on demand (from the Load List Context Menu) or automatically before thy run. Validation consists of checking a group or job fields to make sure it can run. Each check box represents an area of validation that you can choose to enable or disable.

It's recommended to always select all the options.

  • Data file Info: Check the data file information. e.g. data file folder exists or can be created, data file name valid, etc.
  • DB Connection: Check the selected database connection.
  • Scheduling Parameters: Check the group or job's scheduling parameters. e.g. end date cannot be in the past, all required fields must be supplied, etc.
  • Pre Conditions: Check the group or job's run pre-conditions. e.g. check the database connection and SQL if SQL pre-condition.
  • PP Processes: Check the group or job's pre or post process.
  • Run Variables: Check the group or job's run variables. e.g. make sure "Run End Date" run variable isn't used in a pre process, etc.
  • Load Mapping: Check the load mapping. e.g. make sure the destination table and each active destination columns are populated, etc.
  • Other: Any other validation.

Backup Data File after each Load: when this box is checked, data files are automatically backed up in the "LoadBackup" folder after each load job's run. This is a default value and it can be changed individually for each group or job in the Advanced Parameters.

Treat empty strings as DB NULL: when this box is checked, empty strings are treated as NULL for the database (i.e. no value is inserted in the database).

Column Definitions Automatic Load: Column definitions are information describing the columns contained in Data Files and Destination Tables. These settings indicate whether column definitions are reloaded automatically every time a change is made.

  • When Data file name changes: Column definitions are refreshed when load data file name changes.
  • When Data file name changes: Column definitions are refreshed when destination table name changes.