Bulk Insert In Teradata taking alot of time(Using Jdbc driver terajdbc 14.00.00.41)

Database

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

Tags (2)
1 REPLY
Teradata Employee

Re: Bulk Insert In Teradata taking alot of time(Using Jdbc driver terajdbc 14.00.00.41)

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.