Utilities & Loading
A collection of 89 issues
A Beginner's Guide to Teradata Multiload and Fastload
Introduction to Teradata Multiload and Fastload
What is the Teradata Multiload?Teradata Multiload is a utility that supports loading data (INSERT) and other DML statements (UPDATE, DELETE, UPSERT). All DML statements are executed optimally, and changed data blocks are written only once. Furthermore, Teradata can process several tables at once.
Teradata Index Selection: Factors to Consider
Hadoop and Teradata Data Warehousing: A Comparison and Integration Perspective
Hadoop is a buzzword in the world of big data, but its actual value can be concealed by the hype. This article compares Teradata and Hadoop Data Warehousing, highlighting the advantages of leveraging Hadoop's scalability and preprocessing capabilities to improve Teradata's performance. However, the
Teradata Data Type Considerations
Introduction to TPT Teradata: Streamline Your Data Loading
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
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
Teradata Row Retrieval: Understanding Hashing, Indexing, and Search Algorithms
Introduction
Teradata uses various mechanisms, such as hash maps, master and cylinder indexes, and binary and sequential search algorithms, to locate table rows. This article explains the process of locating table rows in Teradata using these elements and techniques.
Hash Maps
Teradata's architecture utilizes the Massively Parallel Processing
Optimizing Performance with Teradata ORDER BY: How Sorting is Done in Parallel Without Bottlenecks
Teradata ORDER BY and Performance
To employ a basic sorting algorithm, all rows must be present in one location for sorting. However, this is not feasible in Teradata, where numerous AMPs each retain a segment of every table. Transporting all the rows to one AMP for sorting would result in
Loading Data into Teradata using Python and Fastload
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