Teradata Bulk Loader

Description

The Teradata Bulkloader transform supports fastloading data into a Teradata database using the fastload command line tool.

Options

OptionDescription

Transform name

Name of the transform this name has to be unique in a single pipeline.

Use control file

Work in control file mode.

Control file

The path to the control file to be used.

Variable Substitution in control file

Make use of POI Variables (eg: ${RUN_ID}) in the control file.

Path to fastload

The path to the fastload command line utility.

Error log

An optional Error log to be created by Fastload.

Connection

A connection to the Teradata DB.

Target table

The table to be loaded.

Truncate table

Truncate the target table before loading.

Data file

The name of the temporary data file.

Sessions

Number of sessions to be used by Fastload.

Error limit

The error limit for Fastload.

Field mapping

Definition of POI <→ DB Field mapping.

Fastload Control File

Runs as a transform within a pipeline completely independent from other transforms.