Utilities & Loading
A collection of 89 issues
A Beginner's Guide to Teradata Multiload and Fastload
Teradata Index Selection: Factors to Consider
The Teradata Tutorial to support the selection of indexes
How much space does the Teradata index occupy?An index can take up surprisingly much space, especially if the Teradata system does not automatically apply Block Level Compression to the index. MANY TIMES, a NUSI can take up the base table&
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
Optimizing Performance with Teradata ORDER BY: How Sorting is Done in Parallel Without Bottlenecks
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