Teradata: Advanced Options

At the “Target Options” page of SQLWays Wizard you can see the button “Advanced”, which opens the window with additional options for target database:

Convert CHAR To VARCHAR If Length Greater
If this option is checked, SQLWays Wizard will convert all the CHAR columns, length of which is greater than the number specified in text box of this option, to VARCHAR with appropriate column length.

Query Band
This option adds SET QUERY_BAND option for the current session or transaction in the generated FLD file. Default value - Empty.

Logging Mechanism
In this option you can define logging mechanism that will be used to connect to the Teradata database. By default the Logging Mechanism is empty, but you can choose other value from dropdown list:

Use Fast Load
“Use fast load” option allows using fastload.exe utility to load the data into the Teradata database. Also for fastload utility please specify such options like “Error files”, “Sessions”, “Tenacity”, “Sleep”, “Errors limit”.

BIN Directory
Specifies the directory where FLOAD utility is located. Can be used only when “Use Fast Load” is checked.

Error Files
You need to specify two error tables where fastload utility will put information about the errors that occurred during the fastload execution. The first error table records translation or constraint violation error. Second error table stores errors related to duplication of values for Unique Primary Index. Default suffixes “_Err1” and “_Err2”. Can be used only when “Use Fast Load” is checked.

Errors Limit
You need to specify the maximum number of rejected errors that fastload utility will put in the first error table. Can be used only when “Use Fast Load” is checked.

Sessions
This option controls the number of sessions to be established with Teradata database. Can be used only when “Use Fast Load” is checked.

Tenacity
Specifies the number of hours during which fastload tries to establish the connection. Can be used only when “Use Fast Load” is checked.

Sleep
Works together with “Tenacity” option. It controls the number of minutes to wait before fastload will retry to establish the connection. Can be used only when “Use Fast Load” is checked.

If you have any other questions regarding the usage of our tool, please contact our support team: support@ispirer.com