Introduction Many data warehouse projects are a failure because an inappropriate data model is chosen at the beginning of the ...

Teradata denormalization as a last resort

What are the Features of the Teradata Identity Columns? What is a Teradata Identity column? The Teradata identity columns feature ...

Teradata Identity Columns to achieve better Performance

Situation and Setup of a Historisation in Teradata Vantage Imagine that the time has come to improve your physical data ...

Teradata Vantage Historisation

Isolation Levels and their Impact on Performance & Concurrency Isolation is the property that determines how transaction integrity is visible ...

Increase Performance with Teradata Load Isolation

What is the Waterfall Model? In the waterfall model, the data warehouse project proceeds from one phase to another. Only ...

5 Common Mistakes Everyone Makes In Using The Waterfall Model

Introduction to Teradata Referential Integrity What is Teradata Referential Integrity? Referential integrity ensures that a value created in a foreign ...

Teradata Referential Integrity

To illustrate the impact these mistakes tend to have on Teradata Data Warehouse projects, let me compare it to a ...

7 Deadly Sins That Destroy A Teradata Data Warehouse

What are Teradata Surrogate Keys? There are several definitions of what a surrogate key is, but on the whole, they ...

Teradata Surrogate Keys Guidelines

Without Teradata CHECK Constraint If a non-indexed column is used in a retrieving step (i.e., WHERE condition) and without Teradata ...

Using Teradata Check Constraints for SQL Tuning

Improve the Performance of your Teradata System After executing the query below, you will probably be shocked by how only a few ...

Teradata Tuning And The Pareto Principle