All Forums Database
geetikak 3 posts Joined 11/14
23 Apr 2015
Bulk Insert In Teradata taking alot of time(Using Jdbc driver terajdbc 14.00.00.41)

Hi All,
I am trying to perform bulk insert operation on teradata database in java. But It taking lot of time. I am doing this insertion in batches. I have explore the FASTLOAD Parmeter also. But it is for laoding huge amount of data or to perform insertion in EMPTY TABLE.
I want to peform bulk insert in existing Table.
Can anyone please tell me how can I decrease the time of  Bulk Insert?
 
Thank you

tomnolan 594 posts Joined 01/08
23 Apr 2015

Consider loading your data into an empty staging table using JDBC FastLoad or JDBC FastLoad CSV, and then executing an INSERT...SELECT statement to copy the data from the staging table to your actual destination table. You can drop the staging table afterwards.

You must sign in to leave a comment.