You can configure a task so that Teradata PT API uses one of the spool modes to extract data from Teradata. By default, Teradata PT API spools data while extracting data from Teradata. For information about the spool modes and their uses, see the Teradata documentation.
You can configure the following source properties for Spool Mode that Teradata PT API uses to extract data from Teradata:
Spool
Teradata PT API spools data while extracting data from Teradata. Data is stored in a buffer and then extracted.
NoSpool
Teradata PT API does not spool data while extracting data from Teradata. The NoSpool mode extracts data quickly without reading the data into a spool file before extracting data. If the database does not support the NoSpool option, Teradata PT API uses the Spool option.
NoSpoolOnly
Teradata PT API does not spool while extracting data from Teradata. If the database does not support NoSpool, the task fails with an error.
ASK INFAPreview
