Loading Archives -

Teradata Utilities – Fastload, Multiload, BTEQ, and TPump

05/06/202304/23/2023 by Roland Wenzlofsky

Learn about Teradata’s load utilities, which can be divided into two groups: those that bypass the transient journal and those that use it. Depending on your requirements, you may choose to load data either way. This article offers advice on how and when to use each tool, including BTEQ, TPump, Fastload, Multiload, and the Teradata Parallel Transporter (TPT). Find out which tool is most efficient for your data quantity and row size.

Improving Teradata Load Performance: Choosing the Right Loading Method

05/04/202304/21/2023 by Roland Wenzlofsky

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.

Teradata TPump: What it is and How it Facilitates Real-Time Data Updates

04/20/202304/20/2023 by Roland Wenzlofsky

Discover Teradata TPump, the real-time loading tool for transactional systems. TPump loads one row at a time, allowing concurrent INSERTs and UPDATEs using row hash locks. With TPump, you can throttle statement rates and execute DML functions, all while bypassing some of the limitations of bulk loading with Fastload or Multiload. Learn about TPump’s performance and limitations, as well as monitoring and error handling. Check out a sample script to get started with Teradata TPump.