Import csv to teradata table directly

Asked By Derrick E Clayton 30 points N/A Posted on - 11/08/2013

import CSV to Teradata table directly idea? CSV to Teradata table without using mload is required. Is it possible?

• Status: Open
• Question Views: 4119
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Feature tips

Answered By Waters Magner 5 points N/A #187249

Import csv to teradata table directly

Yes this is possible. Here are the required steps:

1. The columns in Excel should be in same order as that in Teradata table.
2. You then need to remove the header row from the table as save the file as comma delimited file in excel.
3. Now in SQL set the delimiter as comma ",". You will find delimiter in menu tools options import/export.
4. Go to tools option and change the data format to "yyyy-mm-dd" format. This is required if table contains date field.
5. From Teradata SQL assistant select 'file' and then import data.
6. Now run the command Insert into table name values(?,?,?,?);
7. You need to supply the ? for every column.
8. Highlight the insert query that you have written and press f5. This will ask for file location and then select the appropriate file location.
9. This will load in the order in which it is being shown in text file. 
10. Finally turn off the import data mode and continue querying. You are done.

About Waters Magner

Questions
0

Answers
199

Best Answers
32

• Vote Up 0 Vote Down

• Posted on - 11/08/2013
• Question Category: Feature tips