Teradata

The bulk load subsystem of Virtual DataPort takes advantage of the FastLoad mechanism of Teradata to accelerate loading data into a Teradata database.

This feature is enabled by default. To check it is still enabled, open the data source, click the Read & Write tab of the data source and make sure Use bulk data load APIs is selected. Teradata does not require any changes in its configuration.

At runtime, to perform a bulk data load, Virtual DataPort opens a new connection to Teradata with the parameter TYPE=FASTLOAD. This connection cannot be obtained from the pool of connections of the data source so the execution engine creates a new one to do the bulk data load.