The Teradata Parallel Transporter (TPT) is a Teradata Tools and Utilities (TTU) product. Teradata TPT offers under one roof an SQL-like scripting language that simplifies the syntax of old Teradata Utilities for handling external data (e.g., FastLoad, MultiLoad, TPump, BTEQ, and FastExport). Copying Tables between Teradata Systems A classic approach to perform a database-to-database table

Read More

This article demonstrates how to efficiently load a flat file into an empty table using Teradata TPT. The example was tested on Teradata 16.20. TPT offers a lot of advanced possibilities to load a file but is often overstraining for simple tasks. The example I will show you here uses a simplified method that allows

Read More

What is Teradata TPump? TPump stands for Teradata Parallel Data Pump. Teradata TPump does not move data in large blocks like Fastload or Multiload. Instead, it loads one row at a time, using row hash locks. Using row hash locks allows TPump to do many concurrent INSERTs and UPDATEs on a table. Teradata TPump is

Read More

What is the Teradata Fastexport? Teradata FastExport uses multiple sessions to rapidly move significant data volumes between Teradata Vantage and client utilities. The destination for the exported information could be any mainframe-attached or network-attached file. When Teradata Vantage FastExport is executed, the SQL statements in the FastExport script are executed. Teradata FastExport can export in

Read More

What is a Teradata FastLoad? Fastload is a Teradata Bulk Load Utility used to load vast amounts of data as quickly and efficiently as possible. As a bulk load utility, it bypasses the transient journal and loads data in blocks. The Fastload utility first assembles the client-side data blocks and then sends them to Teradata,

Read More

Teradata BTEQ is the first tool from Teradata for executing SQL queries. You can execute queries, export data, and import data. Teradata BTEQ also offers more possibilities than Teradata SQL Assistant and should be one of your basic tools as a Teradata developer. BTEQ can be used interactively or to execute batch scripts. ETL-Tools versus

Read More

What is a Teradata Macro? The Teradata macro is functionality used to execute multiple SQL queries in one transaction. Either all requests of the macro are successful, or all changes to database objects are rolled back! What are the Features of Teradata Macros? Macros encapsulate application logic and access control to it The code of

Read More

The following two Teradata TPT scripts show how easy it is to export a table from one database and upload it to another database or even Teradata system. In our example, we use bulk loading, which should be used only for larger tables with at least a few hundred thousand rows. Small tables should be

Read More

TPT Teradata – Introduction Those of us who are working for many years with Teradata and its utilities know that the Teradata Parallel Transporter Utility (TPT) merges the functionalities of Fastload, Multiload, TPUMP, BTEQ, and Fastexport into one utility. Teradata attempted to create a common tool in the past, but I assume many of us did not even

Read More