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 Vantage 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

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

Teradata allows only a limited number of bulk loads to be executed together as they consume a lot of resources.  The precise limit depends on your Teradata system. It will be somewhere in the lower 2-digit area. Whenever the utility limit is reached, additional requests will end up in a workload queue. On a heavily loaded

Read More

Teradata has several ways of external loading data. The Teradata load utilities can be divided into two groups: The first group allows us to bring the data as fast as possible into the target table by bypassing the transient journal. The second group uses the transient journal but is slower. Each group has its advantages

Read More