Loading Table Data from a File - Teradata Studio

1. Open the Data Transfer perspective by clicking on the Data Transfer tab.
2. Select a table object in the Data Source Explorer as the destination table for the data load.
3. Right-click the table and select Data > Load Data. If you do not have the Data Transfer perspective open, you are asked to switch to the perspective.
4. In the Data Transfer Wizard, select External File as the Source Type.
5. Click Launch. The Load Data Wizard opens.
6. In the Import Data into <filename>, type the directory path and name of the file that contains the data you want to import. To find a file in your file system, click Browse, select the file, and click Open.
7. In File Type, select one of the following options:

   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.

8. [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.
9. [Default] Select the Stop Loading If Max Error(s) Occur check box and specify the maximum number of errors allowed before the Load operation stops.
10. [Optional] Select the Lock Table check box to lock the source and destination tables during the Load operation.
11. [Optional] Select the Replace Existing Data check box to specify that data in the source file replaces any existing data in the destination file.
12. In step 10, if you selected Delimited Text, complete the appropriate File Options fields.
    1. In Column Delimiter, select the delimiter that you want used to separate data.
       • Comma — Uses commas (,) to separate data in destination file
       • Semicolon — Uses semicolons (;) to separate data in destination file
       • Space — Uses blank spaces to separate data in destination file
       • Tab — Uses Tabs to separate data in destination file
       • Fixed Width — Uses fixed width columns to separate data. Specify in the Fixed Width Columns field a numeric value for the fixed column width.
       • I — Inserts a vertical bar (I) to separate data
    2. Select the Character String Delimiter to use to distinguish string text. The options are " (double-quotes), ' (single quote), or None.
    3. In Line Separator, select one of the following options based on the operating system from which the data is imported. This option enables you to import files with only Carriage Returns (CR), only LineFeeds (LF), or both Carriage Returns and LineFeeds (CR and LF).
       • Windows OS (CR and LF)
       • Prior to Mac OS X v10.0 (CR)
       • Unix, Linux, Mac OS X v10.0 and above (LF)
    4. In File Encoding, select the 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.
    5. In Start Loading At Row Number, type the table row number at which you want the wizard to start loading data. A sample of the input file based on the options you select displays below the File Options. If you change the values selected in File Options fields, the sample row display also changes.
13. Click Finish. The wizard returns you to the Transfer History View where you can view the report on the Load operation success or failure.