TPT_EXTRACT_SCRIPT_TEMPLATE is the Teradata Parallel Transporter default script template. Archive or retirement jobs can use Teradata Parallel Transporter to extract data from Teradata to the Data Vault. You enable Teradata Parallel Transporter in the Teradata source connection.

The script template includes supported Teradata scripting language and parameters. The job uses the script template that is configured in the Teradata source connection to create one script for each table the job exports data from. During the script creation, the job replaces the parameters with values that are specific to the table. The job uses the script to pass the query request to Teradata Parallel Transporter. Teradata Parallel Transporter rewrites the query request to optimize the query for maximum performance and throughput. Then, Teradata Parallel Transporter creates one BCP file for each table.

No additional configuration is required for the script template. TPT_EXTRACT_SCRIPT_TEMPLATE is the default script template name in the Teradata source connection.

Optionally, you can copy the script template and modify the copied script template. You may want to modify the script template if you want to use additional parameters or to change the scripting language. For example, you may modify the script to optimize performance. If you copy the script template, you must update the script template name in the Teradata source connection.