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

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