Dimensions

To hash or not to hash (dimension surrogate keys) ... that is the question?

This article explores why hash surrogate keys should be avoided in a data warehouse and makes the case for sticking with integer surrogate keys.

Jan 30 •

Adam Gilmore

Slowly Changing Dimension

What exactly are Slowly Changing Dimensions, and why should you care about them?

Jun 26, 2024 •

Adam Gilmore

Dimension Tables – An Introduction

A Dimension table is one of the 3 key elements of dimensional modelling used to build a Data Warehouse. This article will give you an in-depth…

May 3, 2024 •

Adam Gilmore

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts