DWHPro helps thousands of visitors every month to become experts in Teradata and data warehouse design and operations by Roland Wenzlofsky

#14 Oct 18, 2022

Offloading your Teradata tables to an S3 object store

With NOS, Teradata Vantage offers an easy way to offload cold data to cheap S3 object stores (AWS S3, Azure Blob, Google…

Read issue →
#13 Oct 15, 2022

Teradata Native Object Store

In this article, we will give you an introduction to how Teradata can access external data stored in object stores,…

Read issue →
#12 Oct 14, 2022

A simple method to query S3 files from Teradata

Do you have cold data that you would like to offload to make room on your Teradata system? If you want to query this…

Read issue →
#11 Oct 12, 2022

How to bypass the Teradata transient journal

Has it ever happened to you that you issued an UPDATE statement on a huge table, and your statement took forever to run?…

Read issue →
#10 Oct 10, 2022

New DWHPro Video - Teradata Sorting

Hello, valued reader of the DWHPro Newsletter, In this article, you'll learn how Teradata is truly parallel at every…

Read issue →
#9 Oct 1, 2022

The Teradata Spoolspace Video

Hi, In this video from DWHPro, you will learn all about Teradata Spool Space. How to optimally set up spool space on…

Read issue →
#8 Sep 30, 2022

Teradata Memory Architecture

This video discusses the memory hierarchy of a modern computer system and how it affects Teradata performance, and the…

Read issue →
#7 Sep 26, 2022

8 Teradata Access Paths You Should Know!

Hi, valued reader of the DWHPro Newsletter, The optimizer has various access paths when creating the execution plan.…

Read issue →