About Smart Load Wizard (Teradata, Aster) | Teradata Studio/Studio Express - About Smart Load Wizard (Teradata, Aster) - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
ztp1648839236373.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
Product Category
Teradata Tools and Utilities

The Smart Load Wizard enables you to create Teradata or Aster tables from data stored in an external file. This screen varies with destination system and options selected.

Input File
Enter the path and name for the file to import or click Browse to find a file on your file system.
File Type
Select the type of file to import. The default file type is delimited text. The Microsoft Excel file type has options for files with .xlsx and .xls extensions.
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 Data If Max Error(s) Occur
Select to stop the data loading if the number of errors you enter occurs.
Drop Table If Max n Error(s) Occur
Select to drop the table if the number of error you enter occurs.
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 Use 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"
Quick Scan
Select to scan the file partially when trying to derive a table from the imported data.
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
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), only Carriage Return (CR), or both Carriage Returns and LineFeeds (CR and LF). The options are:
  • Windows OS (CR and LF)
  • Prior to Apple macOS 10.0 (CR)
  • Apple macOS 10.0 and after (LF)
File Encoding
Specify the type of encoding to used for the file.