[TERADATA] Uploading csv to table

1. Create table

CREATE MULTISET TABLE test_table
(
AccountID INTEGER,
Score DECIMAL(18,4),
Score_Class VARCHAR(50),
Load_Date Date
)


2. Write the insert command. Exactly same number of question marks as in the table definition
insert into test_table VALUES(?,?,?,?)

3. Define the delimiter of the file in

Tools -> Options->Export/Import

4. Make sure to ignore first line of the file as it is a header

Tools->Options->Import   Check the "Ignore the first record in the import file (Skip Header)