Six Stars

Perfomance while loading csv into table

I am trying to load csv file into table , but performance is very very very slow , File is comma delimited with 6 million rows , lookup table is feed generated ID and it inserts into table 

 

help me the changes to loaded faster for 6 million rows ...  

 

12sd.PNG

 

 

In tmap i have below 

 1112.PNG

1 REPLY
Six Stars

Re: Perfomance while loading csv into table

I tried below approach . first load into file and use that file and load into table 

 

still slow

 

3123.PNG