15.10 - Step 2 – Specify Advanced Settings [optional] - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

Step 2 – Specify Advanced Settings [optional]

To set load options, edit a table name, or specify log tables

If these options do not need to be modified, proceed with Step 3 – Launch a Script.

1 [Optional] To set up bulk loading options, edit a table name, or change the location of the log tables involved in the operation, click Settings to open the Advanced Settings dialog box.

The following items are available in this dialog box:

  • Bulk loading options – When updating tables, disable either or both of these options to optimize performance. The options are available only when a data source supports the option.
  • Index updates required – If this option is cleared, the OLE DB provider is not required to update indexes based on inserts or changes to a row set. This will require indexes to be re‑created after changes are made to a row set.
  • Referential integrity check – If this option is cleared, the OLE DB provider is not required to check the referential integrity constraints or to enforce changes made to a row set.
  • Table name – Enter or change the name of the destination table. By default, the quoted and qualified table name is displayed; however, the double quotes must be removed for data providers, such as Oracle, that do not support double quotes. In other words, the table name must be quoted and qualified as required by the destination source.
  • If you enter a name for a table that does not exist, a new table will be created.

  • Location of log tables – Specify the location of the restart log tables for the operation. The name of this database gets included in the LOGTABLE command of Teradata FastExport scripts created by the Teradata OLE DB Access Module.
  • User’s default database – Teradata FastExport scripts search for the log table in the default database that is defined for the user name by the LOGON command.
  • Source database – Restart log tables are located in the same database as the tables being exported.
  • Other database – Specify a database name other than the default or source database.
  • Session character set – Specify the character set for the current session used for scripts and data transfer.
  • Session character set affects the data transfer mode between databases.

    For arbitrary Unicode strings to be correctly transferred, the following must occur:

  • In Session Character Set, select UTF‑8/UTF‑16 (a Teradata session character set).
  • Ensure that the source (for a load operation) or the destination (for an export operation) properly handles Unicode.
  • Perform the necessary configuration of the data source or OLE DB Provider.
  • During an export, character data is received from a export utility (that is, FastExport or BTEQ) in the Teradata session character set encoding. The character data is then converted using the DBTYPE_WSTR (UTF‑16) data type and passed to the OLE DB Provider that is specified in the Select a destination box.

    For additional information character sets, see “Character Set Support” on page 55.

  • Checkpoint interval – Specify a checkpoint interval. This value is used in the CHECKPOINT specification in load scripts generated for Teradata FastLoad, Teradata MultiLoad, and TPump jobs. The field is enabled for load jobs only.
  • If a value is entered in the Checkpoint interval field, system performance might be enhanced if values are also added to the Rows per Fetch and Buffer size boxes, and if the Enable scroll backwards option is selected. For more information about how to set these fields, see “Access Module Factors” on page 63.

  • Rows per Fetch – Enter the number of rows returned for Teradata MultiLoad jobs. Increasing the number of rows might improve efficiency.
  • Buffer size – Enter a number to represent the size of the buffer for a TPump job. Increasing the buffer size might improve efficiency.
  • Enable scroll backwards – If this option is selected, restarts begin at the most recent checkpoint; however, this selection might slow performance. If this option is left blank, jobs restart from the beginning of the script.
  • Enable improved UTF8 data transfer – If this option is selected, the OLE DB Access Module transfers fixed length character data as variable length character data, improving data transfer in import jobs in which the source is not Teradata Database. This option is available for selection only for UTF‑8 session character set in import jobs.
  • 2 Close the Advanced Settings dialog box, and proceed with Step 3 – Launch a Script.