Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

Teradata Load Settings

Teradata Load Settings

On the
Runtime Settings
tab >
Teradata Load Settings
view, you can configure data load settings for Teradata targets.
The following table describes the fields in this view:
Field
Description
Default
Teradata Load Utilities in Indicator mode
If you selected the
Binary length prefix
option, indicates whether to set the indicator bits in the binary output for column values that contain NULL data.
This option must be selected for the
Use Teradata Parallel Transporter (TPT)
and
Enable Teradata Direct Data Stream
options to be available.
Selected
Use Teradata Parallel Transporter (TPT)
Indicates whether Fast Clone uses Teradata Parallel Transporter (TPT) to load source data to the target database. If you select the
Enable Teradata Direct Data Stream
option to use DataStreamer, this check box is automatically selected and cannot be edited.
Selected
Loader to be used
The Teradata load utility that the Fast Clone generated load script calls to load data to the Teradata target. Options are:
  • Teradata FastLoad
    . Use the Teradata FastLoad utility, or use the TPT Load Operator if the
    Use Teradata Parallel Transportor (TPT)
    check box is selected.
  • Teradata MultiLoad
    . Use the Teradata MultiLoad utility, or use the TPT Update Operator if the
    Use Teradata Parallel Transportor (TPT)
    check box is selected.
  • Teradata Parallel Data Pump
    . Use the TPT Stream Operator. This option is available only when the
    Use Teradata Parallel Transporter (TPT)
    check box is selected
Teradata FastLoad
Load Sessions
The number of sessions that the load utility opens to load source data to each target table.
2
Binary length prefix
Indicates whether to unload source data in binary format. Each binary-format record includes a 2-byte field that indicates the total length of the record, the optional bytes for null values, and the data. If you select the
Enable Teradata Direct Data Stream
option to use DataStreamer, this check box is automatically selected and cannot be edited.
Not selected
Binary length prefix endianness
If you selected the
Binary length prefix
option, specify the endianness of the binary output. This parameter determines the format of the integer that specifies the length of records and fields in the binary files. Options are: LITTLE ENDIAN and BIG ENDIAN.
LITTLE ENDIAN
Enable Teradata Direct Data Stream
Select this option to have DataStreamer call TPT to load source data to the target database. DataStreamer uses the TPT Load Operator, Update Operator, or Stream Operator to load data, depending on the option that is selected in the
Loader to be used
list.
Not selected
Drop and rebuild tables in Teradata prior to load
Select this option if you want DataStreamer to drop and re-create the Teradata tables before loading source data into the tables.
Not selected
Skip writing the output data into files
If you use DataStreamer, Fast Clone skips writing unloaded data to output files or pipes.
If you do not use DataStreamer and need to troubleshoot unload jobs, clear this parameter to write the data to output files.
Depends on DataStreamer use
Max errors
If you use DataStreamer, the maximum number of errors that can occur when streaming data to a Teradata target. If the number of errors exceeds this maximum, DataStreamer ends with an error.
100000

0 COMMENTS

We’d like to hear from you!