Fastload Archives - Page 2 Of 3 -

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

04/11/202605/03/2023 by Roland Wenzlofsky

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 …

Loading Data into Teradata using Python and Fastload

04/11/202605/02/2023 by Roland Wenzlofsky

This article assumes prior basic knowledge of Python and demonstrates the easy process of loading data using Python and the Teradata SQL Driver for Python with Fastload. If you are using Windows, we recommend using WinPython if you don’t have Python installed yet. Because a Jupyter Notebook is included, we use it to show how …

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

04/11/202605/02/2023 by Roland Wenzlofsky

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 flat files …

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

04/11/202605/02/2023 by Roland Wenzlofsky

1. Complete and up-to-date Statistics At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer employs statistics to formulate the optimal execution plan for our query. The adequacy of statistics or dynamic AMP sampling varies according to the data demographics. To initiate optimization, updated statistics must be provided to the …

Optimizing Teradata Stage Table Design for Faster Load Times: The Importance of Data Types and Sizes

04/11/202605/02/2023 by Roland Wenzlofsky

Learn how to optimize load times in Teradata by choosing the correct data types and sizes for stage tables. Read on for a real-life example.

VantageCloud Lake: Turbocharge Your Data Warehousing with Teradata’s Innovative Solution

04/11/202604/30/2023 by Roland Wenzlofsky

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 …

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

04/11/202604/28/2023 by Roland Wenzlofsky

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 …

Understanding Teradata’s Primary AMP Index for Improved Performance

04/11/202604/28/2023 by Roland Wenzlofsky

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 …

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

04/11/202604/28/2023 by Roland Wenzlofsky

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 …

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

04/11/202604/28/2023 by Roland Wenzlofsky

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 …