Hi, I am exploring the various options to speed up the data loading to a Teradata database using JDBC Driver. from the description of SESSIONS parm, it looks like, it is applicable to only FastLoad and FastExport mode of operation. Is that interpretation correct? or does it happen that number of sessions can speed up the data loading over normal JDBC mode ?
The SESSIONS connection parameter only applies to JDBC FastLoad and JDBC FastExport connections.
The SESSIONS connection parameter is not applicable to a regular SQL connection.
When you are using a regular SQL connection, PreparedStatement batch updates provide the best performance for inserting data. The optimal batch size depends on the size of the your data in each inserted row, so you should test a range of batch sizes from about 500 rows up to about 5000 rows per batch.