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?
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.