Transfer Vantage Data | Load Data to a Vantage Table | Teradata Studio - Loading Data to a Vantage Table - Teradata Studio

Teradata® Studio™ User Guide
Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In Data Source Explorer right-click the table and select Data > Load Data.
  2. In the Data Transfer wizard, select the Source Type.
  3. Click Launch.
  4. Do one of the following:
    If you selected this Source Type Complete these steps:
    Hadoop
    1. Select the Hadoop Connection Profile.
    2. Select the database containing the table you want to load.
    3. Select the table you want to load then click Next.
    4. Select the Destination Column Name/Type for each Source column name/type. By default, the column data type of the Vantage table is based on the column data type of the source Hadoop table. Verify the column data type and use the list to select a different data type if needed. You are able to set the data type for each column in the table.
    5. Specify if you want to Append data to destination table or Replace existing data in destination table.
    6. Specify a Job Name.
    Teradata
    1. Select the Teradata Connection Profile.
    2. Select the database containing the table you want to load.
    3. Select the table you want to load then click Next.
    4. [Optional] Select the Lock Table check box to prevent editing during the data transfer, then click Next.
    5. Specify the column information you want to load, identify if you want to append or replace data in the destination table, specify a Job Name.
    6. [Optional] Click Next to view the SQL generated by the choices you made.
    External File (FastLoad)
    1. Click Browse and specify and Input File.
    2. Select the File Type.
    3. [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.
    4. [Optional] Check the Stop Loading if Max Error(s) Occur check box if you want to stop the load process if the number of errors you specify occur.
    5. [Optional] Select the Lock Table check box to lock the table during the load operation.
    6. [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.
    7. [Optional] Select the Include Null Row box if you want to include null rows in the table.
    8. [Optional] Select the Use System Locale box if you want to use the format displayed.
    9. If you selected the Delimited Text file type, complete the fields under File Options.
    10. If you selected an Excel file type, select the Import Worksheet you want to use and specify the row number at which to start loading data in Start Loading At Row Number.
  5. Click Finish.

    The load job starts, and data is loaded to the table.

    [Teradata and Aster]
    • If there is a column mismatch in the data load process and you did NOT set the Data Utilities preference to be prompted in case of column(s) mismatch, then the data load process is completed without any user interaction.
    • If there is a column mismatch in the data load process and you set the Data Utilities preference to be prompted in case of column(s) mismatch, then do one of the following to complete the data load process:
      Option Action
      Click OK.
      • If the file rows contain fewer columns than table columns, then nulls will be added to remaining columns while processing those specific rows.
      • If the file rows contain more columns than table columns, then those extra columns will be removed starting from the end of row while processing those specific rows.
      • If the file has rows where the datatype of a column does not match with table columns datatype, then those rows will be ignored during processing.
      Click Cancel.
      • The rows up to the first error row will be stored in the table.
      • An exception is logged in teradata.log stating you selected Cancel
      • The transfer process is stopped.