Often we need to quickly load a text file without writing elaborate loading scripts. If we want it to be quick and easy, it is neither useful to design TPT scripts nor to use any ETL tools (Informatica, AB Initio, Datastage, etc.). Teradata with Python is often the simplest choice. In this article, I will

Read More

In this article, we assume that you already have basic knowledge about Python. We will show step by step how easy it is to load data using Python and the Teradata SQL Driver for Python using Fastload. If you are using Windows, we recommend using WinPython if you don’t have Python installed yet. Because there

Read More

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