Coming soon: A Modern Web-Based Alternative to Teradata Studio Popular

Illustration of a person in a suit standing beside a database cylinder

Introducing DWHPro Query Master: A Modern Web-Based Alternative to Teradata Studio As Teradata professionals, we’ve all been there: waiting for Teradata Studio to launch, dealing with Java updates, or struggling with its dated interface when all we want to do is run a quick query. That’s why I’m excited to introduce DWHPro Query Master – …

Read more

Fast multi-file export of Teradata query results using only Teradata SQL Assistant Most read

Icon of a chrome hammer inside an orange circle over a brick pattern

I was recently approached to support a case of importing the results of a Teradata query into a third-party vendor database. On the export side, Teradata happily wrote close to 60 million rows into a single, wide CSV file. On the other side, the import process to the target database could not cope with the …

Read more

A Beginner’s Guide to Teradata Multiload and Fastload Most read

Icon of a chrome hammer inside an orange circle over a brick pattern

Introduction to Teradata Multiload and Fastload MultiLoad does not run in isolation: how the utilities are throttled as a workload of their own and the smaller-volume alternative in BTEQ. Next steps Next: query logging Review: SET and MULTISET tables Return to the Teradata learning path

Introduction to TPT Teradata: Streamline Your Data Loading Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

Learn about Teradata’s Parallel Transporter Utility (TPT), the all-in-one tool that combines Fastload, Multiload, TPUMP, BTEQ, and Fastexport functionalities. Discover the benefits of TPT’s consistent syntax and parallelism, as well as a comprehensive overview of its operators.

How to Simplify Database-to-Database Table Copying with Teradata Parallel Transporter (TPT) and tdload Popular

Icon of a chrome hammer inside an orange circle over a brick pattern

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

Loading Data into Teradata using Python and Fastload Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

Create the target table once in a dedicated test schema and leave it empty before loading. The function does not drop an existing table. Use credentials from your environment and validate source widths before FastLoad. The audit tested the loading protocol and stored values with a small deterministic fixture; the 100,000-row random generator below is …

Read more

How to Load a Flat File into an Empty Table with Teradata TPT: A Simple Example Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

This article illustrates loading a flat file into an empty Teradata table using TPT. The example was successfully tested on Teradata 16.20. Although TPT does offer a wide range of advanced options for loading files, it can be overwhelming for basic tasks. In this demonstration, I will present a simplified approach to loading compatible delimited …

Read more

Unlocking the Power of Teradata Macros: Features, Creation, and Execution

Icon of a chrome hammer inside an orange circle over a brick pattern

What is a Teradata Macro? A macro executes its statements as a request, with transaction behavior governed by session mode and any enclosing transaction. Do not infer an unconditional commit. Quoting the Subscriber identifier allowed CREATE/REPLACE, EXECUTE and DROP to complete in the fixture. What are the Features of Teradata Macros? How is a Macro …

Read more

Teradata Utilities: Fastload, Multiload, BTEQ, and TPump Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

Learn about Teradata’s load utilities, which can be divided into two groups: those that bypass the transient journal and those that use it. Depending on your requirements, you may choose to load data either way. This article offers advice on how and when to use each tool, including BTEQ, TPump, Fastload, Multiload, and the Teradata Parallel Transporter (TPT). Find out which tool is most efficient for your data quantity and row size.

Protected by Security by CleanTalk and CleanTalk Anti-Spam