Teradata Loader

The Teradata Loader allows you to load data to any Teradata database configured in the Spectrum Data Integration platform.
Note: The loader is supported only on Windows systems.
Option Name Description
Connection Select a Teradata connection.
The dropdown displays all the connections you have configured. To configure a new connection or edit any existing connections, click the Manage Connections link. It takes you to the Connections page in the Spectrum Management Console. For details on configuring new connections, see Connections.
Note: Click the Refresh icon to update any modification, deletion or addition to your list of connections.
Table Specify the table to which you want to write the data.
  1. Click the Browse button ([...]). The Select Table pop-up window is displayed, which shows a list of the tables and views.
  2. Choose the required table.
    Note: You can also use the search text box on the top of the pop-up window to narrow down your search.
  3. Click Select.
The fields of the selected table are displayed in the Fields section on the right side of the page. These are the details displayed:
  • Database Fields: This column lists the field names in the database. You cannot modify these field names.
  • Stage Fields: This column lists the field names used in the data flow. You cannot modify these field names
  • Types: This column lists the data type of each field.
Load method
Specifies the method of writing data to the Teradata database tables.
  • Select Insert to write data to an empty table
  • Select Append to write data to an existing data table.
  • Select Truncate and Insert to truncate the data before writing it to the database table.
Log file folder Select the folder location for saving the log files of the upload process.
Generate bad file Specify Yes to generate a log of the records that failed to get uploaded.
Bad file folder Specify the path of the directory for saving the log of failed records. The log gives details, such as error codes and error field names of the failed records.
Maximum errors allowed Specify the limit of permitted errors for the upload session. If the number of errors exceeds this value, the upload process pauses.