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

DWHPro May 5, 2023

Maximizing Performance and Space Savings: Teradata Compression Techniques

Introduction to Teradata Compression Note: Teradata Block Level Compression is now permanently enabled and cannot be…

Read article →
DWHPro May 5, 2023

Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata

Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique…

Read article →
DWHPro May 5, 2023

Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More

This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two…

Read article →
DWHPro May 5, 2023

A Beginner’s Guide to Teradata Multiload and Fastload

Introduction to Teradata Multiload and Fastload Introduction to Teradata Multiload and Fastload

Read article →
DWHPro May 5, 2023

How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study

The primary goal is to show how the number of rows per base table data block impacts selectivity. The example highlights…

Read article →
DWHPro May 5, 2023

Teradata Index Selection: Factors to Consider

The Teradata Tutorial to support the selection of indexes The Teradata Tutorial to support the selection of indexes

Read article →
DWHPro May 3, 2023

Teradata Join Strategies: How to Optimize Join Operations

Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. The paired…

Read article →
DWHPro May 3, 2023

Mastering Teradata Performance Tuning

The Art of Teradata Performance Tuning As a Teradata Performance Tuner, technical expertise and experience are…

Read article →