Use teradata fastload

Step 1: First open teradata fastload.exe

Step 2: paste the import script

 

 

Script:

Sessions 4; errlimit 25; set record vartext ","; logon localhost/teradata_education, educate;/* localhost: IP address; teradata_education: User Name; educate: password */drop table pt_temp_p.rfm_label; drop table partition; Create Multiset table pt_temp_p.rfm_label (r varchar (20), f varchar (20), m varchar (20 ), CNT varchar (20), lab varchar (20); record 2; defineid0 (varchar (20), R (varchar (20), F (varchar (20 )), M (varchar (20), CNT (varchar (20), lab (varchar (20) file = C:/tmp/rfm_label.csv; /* Source File Location */begin loading pt_temp_p.rfm_labelerrorfiles values, values; insert into pt_temp_p.rfm_label values (: R,: F,: M,: CNT,: Lab); end loading; logoff;
 

Step 3: view the table in teradata:

Select *

From pt_temp_p.rfm_label;

 

 

For more details, see http://www.cnblogs.com/toughhou/p/3813668.html

 

Use teradata fastload