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.
- Import 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.
- 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), 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.