16.10 - Load Data Wizard (Teradata, Aster) - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
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 path and name of the file from which to import data and to specify the server path to its location in the file system. To locate an existing file, click Browse and navigate the file system to select a file.
File Type Select the type of file to be imported. You can choose to load data from a text file, such as a.txt or.cvs file, or from a Microsoft Excel file. Choose between a.xslx file, or.xls (Microsoft Excel 97-2003) file. The file data options change depending on which type of source file you selected.
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.
Include Null Row Select to include null rows in the table.
Use System Locale Select to use the formatting for date, timestamp, digit grouping symbol, and decimal symbol based on the country and language setting for your operating system. A preview of the formatting is displayed.
When system locale is not selected, Teradata Studio accepts the following formats:
  • Numbers: Comma as digit grouping symbol. For example, 1,234,567. Dot as decimal symbol. For example, 1,234.00
  • Dates: "yyyy-MM-dd", "yyyy/MM/dd", "MM-dd-yy", "MM/dd/yy", "MM-dd-yyyy", "MM/dd/yyyy"
  • Timestamps: "MM/dd/yy hh:mm:ss.S","MM/dd/yyyy hh:mm:ss.S", "MM-dd-yy hh:mm:ss.S", "MM-dd-yyyy hh:mm:ss.S", "yyyy/MM/dd HH:mm:ss.S", "yyyy-MM-dd hh:mm:ss.S", "MM/dd/yy hh:mm:ss","MM/dd/yyyy hh:mm:ss", "MM-dd-yy hh:mm:ss", "MM-dd-yyyy hh:mm:ss", "yyyy/MM/dd HH:mm:ss", "yyyy-MM-dd hh:mm:ss"

The File Options change depending on the file type you select, and the destination. For example, the Delimited Text options are:

Option Description
Column Delimiter Specify the column delimiter used in the input file.

This does not apply to Hadoop.

Character String Delimiter Specify the character string delimiter used in the input file.

This does not apply to Hadoop.

Line Separator 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.
Start Loading at Row Number Specify the table row number where the Load operation begins.

A preview table at the bottom of the screen displays a sample of the data in the input file, based on the File Options. The table data includes column name, column data type, and values in table rows. If the sample data is not displayed correctly, change the File Options to correctly represent the input file format.

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