Sunday, April 9, 2017

Teradata Tutorial




Import CSV file as a table in Teradata


1. First create the table you want with the structure of the file.

Create table dp_cad_analtyics.A
(
Testcol1 varchar(20)
, Testcol2 varchar(20)
);

2. Then modify the below query accordingly so that the number of question marks are equal to the number of columns

Insert into dp_cad_analytics.A
Values
(?,?);


3. Select the option of "import data" from the "File" menu and execute query. It will ask for the file.




No comments:

Post a Comment