Sign in Subscribe

Utilities & Loading

A collection of 89 issues

Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks

Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back

Improving Teradata Load Performance: Choosing the Right Loading Method

Learn how to optimize your Teradata Load Performance by choosing the right loading method per table. Bulk loads for large tables and transactional loads for small ones. Find out more in this article.

Data Modeling Considerations for Teradata: SET and MULTISET Tables

Discover the differences between Teradata MULTISET and SET tables for effective data modeling. Learn how to avoid duplicates and improve performance.

Teradata FastLoad: Bulk Load Your Data Efficiently

Discover the power of Teradata FastLoad - the bulk load utility that efficiently loads vast amounts of data, bypassing the transient journal. Learn more here.

Teradata Denormalization for Performance Tuning

Avoid data warehouse project failures by choosing the right data model. In this article, we explore denormalization techniques for when it makes sense, including repeating groups, prejoins, and derived information. We also discuss alternatives to denormalization, such as Global Temporary Tables and

Column-Oriented Storage in Teradata: A Solution for Big Data Challenges

Learn about Teradata's column-orientated storage, which offers an alternative way of laying out data on disks, benefiting data retrieval in Big Data times. This article explains how columnar tables work, how they differ from row-oriented databases, and how you can create them in Teradata 14.00.

Teradata Stored Procedures & Error Handling: A Guide for Effective Programming

Learn how to handle errors in Teradata Stored Procedures. Error handlers provide event-driven functionality and make error handling more efficient.

Never Again "No More Room In Database". I'll Show You How!

Discover the exciting new features of Teradata Version 16.00, which can significantly improve data warehouse administration and loading. Learn how to avoid error messages and manage skewed tables with the new Global Space Soft Limit and SKEW features.

Streamline Your Tasks with Teradata Macros: Reusable Blocks of SQL Code for Improved Efficiency

Learn how Teradata macros can improve your database efficiency with reusable blocks of SQL code. Create macros once, execute them anytime!

Teradata Primary and Secondary Index: Understanding the Differences and Importance for Performance Tuning

Learn about the Teradata Primary Index and how it differs from a primary key. Discover the benefits of defining a primary index and how many can be created per table.