Load Data Wizard - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Load Data Wizard enables you to load data from an input file into a table using either JDBC FastLoad or batch operations. The input file can be a delimited text file or an Excel file. If the table is not empty, the Load Data Wizard appends or replaces the existing data.
JDBC FastLoad operations are not applicable to Aster data transfers. The Load Data Wizard contains the following elements:
Option Description
Input File Specify the file to import.
File Type View a list of file types that can be imported like Delimited Text, Excel, and Excel (97-2003).
Column Labels in First Row Select to specify that the first row in the file contains the column labels so that the first row in the file is ignored.
Stop Loading If Max Error(s) Occur Specify the maximum number of errors allowed before the wizard stops the Load operation.
Lock Table Select to prevent row lock errors.
Selecting this option may cause the import operation to be slow.
Replace Existing Data If the table is not empty, check this option to replace the existing data. Leaving it cleared appends the loaded data to the existing data. If the table is empty, this option is grayed out.

The File Options change depending on the file type you select. The Delimited Text options are:

Option Description
Column Delimiter Specify the column delimiter used in the input file.
Character String Delimiter Specify the character string delimiter used in the input file.
Line Separator If you selected the Delimited Text file type, the File Options section enables you to specify the type of column delimiters, character string delimiters, and character encoding the data in the imported file uses. If you specified an EXCEL spreadsheet as the input file and selected either EXCEL (.xlsx) or EXCEL 97-2003 (.xls) as the file type, you can import data from a single worksheet in the file by selecting a worksheet name in Import Worksheet. The Line Separator options enable you to import files that have only LineFeed (LF), as in Unix and Linux, or only Carriage Return (CR) as in Mac OS/X prior to v10.0, or both, as for Windows. The options are:
  • Windows OS (CR and LF)
  • Prior to Mac OS X v10.0 (CR)
  • Unix, Linux, Mac OS X v10.0 and above (LF)
File Encoding Specify the type of encoding to used for the file.
Start Loading at Row Number Specify the table row number where the Load operation begins.

The Excel options are:

Option Description
Import Worksheet Import Worksheet - View a list of worksheets found in the specified Excel file. Specify which worksheet you want to import.

Data contained in the external file displays at the bottom of the wizard screen. Table data includes column name, column data type, and values in table rows.

When you click Finish, the results display in the Teradata SQL History view. Click the Message tab to view detailed messages.