Enabling Bulk Loading for SELECT and INSERT Statements
Optionally, enable bulk loading for SELECT and INSERT statements. Netezza, Teradata, and SQL Server require extra steps to use this feature. Other data sources might support this feature, but they require no extra configuration.
To enable bulk loading for SELECT and INSERT statements
1. Open Studio.
2. Select Administration > Configuration.
3. Locate the Enable Bulk Data Loading configuration parameter.
4. Set the value to True.
5. Click Apply.
6. Click OK.
To complete configuration of Teradata bulk loading for SELECT and INSERT statements
1. Right-click the data source name in the Studio resource tree and select Open.
2. Select the Advanced tab.
3. Set values on the Advanced tab for Enable FastLoad/FastExport for large tables, FastExport Session Count, and FastLoad Session Count.
4. Save your settings.