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

DWHPro Apr 28, 2023

Teradata Columnar Solution: Advantages and Disadvantages

How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The…

Read article →
DWHPro Apr 28, 2023

Teradata Cloud Solution: Security, Backups, Sizing and More on AWS

Teradata transitioned to the cloud to prevent disconnection from contemporary cloud-based databases. I will…

Read article →
DWHPro Apr 28, 2023

Improving Database Performance and Security with Teradata Write-Ahead Logic (WAL)

Accessing data has always been the bottleneck of database systems. Once the data resides in the main memory, it can be…

Read article →
DWHPro Apr 28, 2023

Understanding Teradata’s Primary AMP Index for Improved Performance

Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the…

Read article →
DWHPro Apr 28, 2023

Switching from Teradata to Snowflake: What to Know About DML Statements and Data Deletion

In this blog post, I will show you what you need to pay special attention to when switching from Teradata to…

Read article →
DWHPro Apr 28, 2023

Zero-Copy Clones: A Space and Time-Saving Solution for Database Management with Snowflake

What Are Zero-Copy Clones? We are all familiar with creating table backups before performing specific operations. This…

Read article →
DWHPro Apr 23, 2023

Formatting Date and Time Values in Teradata: Common Questions Answered

This article will address some common questions about formatting date and time values in Teradata. Teradata is a…

Read article →
DWHPro Apr 23, 2023

How To Speed Up Your PPI Tables With A Secondary Index

Teradata offers various options for designing Partitioned Primary Index Tables. The optimal design choice depends on the…

Read article →