ETL

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 •

Understanding Extract Transform and Load Design

ETL stands for Extract, Transform and Load. It refers to the process of extracting data from the Source systems, transforming it into the star schema…

Jan 31, 2021 •

Persistent Staging Case Study – Employee Fact in Human Resources Data Warehouse

This post is the second in a series of detailed cases studies discussing the ETL strategies that can be used when a Persistent staging layer is included…

Jul 25, 2018 •

Why you need a Persistent Layer in your Data Warehouse – Top 5 Reasons

Why you Need a Persistent Layer

Jul 24, 2018 •

What is a Persistent Layer?

The persistent layer contains as set of persistent tables that record the full history of changes to the data of the table/query that is the source of…

Jul 19, 2018 •

#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