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

The Importance of Up-to-Date Statistics for Teradata SQL Tuning Widely read

Illustration of a stopwatch dial on an orange paint-splash background

The DBQL example needs configured logging and a bounded time window. HASHAMP()+1 assumes the relevant map/AMP scope; it may misrepresent a request using only a subset of AMPs. Use the actual participating-AMP count for meaningful skew/impact calculations, and clear temporary query bands after the measured workload. 1. Complete and up-to-date Statistics At the start of …

Read more

Teradata VantageCloud Lake: Architecture and Use Cases Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Introduction Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures. Teradata is a powerful and scalable relational database management system designed to …

Read more

The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance

Illustration of a stopwatch dial on an orange paint-splash background

Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …

Read more

Understanding Teradata’s Primary AMP Index for Improved Performance Popular

Illustration of a stopwatch dial on an orange paint-splash background

Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index. This blog post will demonstrate a Primary AMP Index’s benefits and optimal usage for improving load and query performance. First, let us examine Teradata’s approaches over the …

Read more

Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance Popular

Illustration of a dense isometric network of connected data nodes

Introduction to Teradata Referential Integrity Teradata implements 3 Types of Referential Integrity. 1. What is Standard Referential Integrity? The Standard Referential Integrity checks every Row INSERT, DELETE, or UPDATE immediately to ensure referential integrity. A reference index sub-table is required for referential integrity. Violation of referential integrity results in the failure of execution and generates …

Read more

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations Popular

Illustration of a stopwatch dial on an orange paint-splash background

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam