16.00 - Loading Data to an Aster Table - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
You can select a Teradata Aster Database table in the Data Source Explorer and load data to the table using the Data Transfer Wizard.
  1. Open the Data Source Explorer and navigate to a table object in an Aster database.
  2. Right-click the table and select Aster > Load Data.
  3. In the Data Transfer Wizard, select External File as the Source Type.
  4. Click Launch.
  5. In the Load Data Wizard, type the directory path and name of the file that contains data you want to load. You can find a file in your file system by clicking Browse to navigate to and select the file.
  6. Select one of the following options in File Type to describe the data in the input file:
    Option Description
    Delimited Text Text file that uses delimiters to separate data; such as, commas or semicolons in a TXT or CSV file.
    Excel (.xlsx) Microsoft Excel file with.xlsx file extension.
    Excel 87-2003 (.xls) Microsoft Excel file with.xls file extension.
  7. [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
  8. [Optional] Select the Lock Table check box to lock the table during the load operation.
  9. [Optional] Select the Replace Existing Data check box if you want the existing data in the Aster table to be replaced by the loaded data.
  10. If you selected Delimited Text as the file type, complete these fields:
    Field Description/Action
    Column Delimiter Type of delimiter to be used. The options are:
    • Comma
    • Semicolon
    • Space
    • Tab
    • | (vertical bar)
    Character String Delimiter Distinguishes a string text. The options are:
    • " (double-quotes)
    • ' (single quote)
    • None.
    File Encoding Character set to use to encode the data. The options are:
    • UTF-8
    • utf-16
    • ISO-8859-1
    • UTF-16BE
    • UTF-16LE
    • US-ASCB
    • Cp1252.
  11. If you selected Excel (.xlsx) or Excel 97-2003 (.xls), select the Excel worksheet from which to load the data.
  12. Click Finish.