This is the third and final blog a part of my deep dive series for dimensional modeling. Today, I will focus on Bridge Tables in…
In this blog post, a part of my deep dive series, I will focus on Degenerate Dimensions in this post. When introducing the concept of…
In my previous post about Slowly Changing Dimensions (SCDs), I provided you an overview of the four most common SCDs types and how they are…
My wife has a PhD in Global Public Health and her career has brought me and our two children all over the world. Many years…
Welcome to the fourth and final entry in my series on the dice game called Farkle. In parts one and two I covered the basic rules…
In my previous two blog postings in this series, I’ve covered the basics of the dice game Farkle and developed a simple way of modeling…
My wife and I love to Farkle and it drives our kids crazy. Don’t be offended; Farkle is a dice game played with six dice…
In my previous Operational Data Store (ODS) blog, we discussed how to design an ODS. In this post, I will describe how to optimize the…
With the Super Bowl just around the corner here in the United States, I recently found myself trying to think of a football-themed blog posting. …
The definition of an Operational Data Store (ODS) is a subject-oriented, integrated, volatile collection of current data designed to support the tactical decision-making of an…
You will inevitably come across a time when a source system will allow the updating of transaction records. This drives data modelers, ETL developers, analytics…
In my last post I discussed late arriving facts, and although it is slightly annoying to receive delayed transaction data, the impact on the ETL…
Late arriving facts are those transactions which are delayed in arriving to the warehouse. For Type I data warehouses there is no real impact but…
Factless facts are those fact tables that have no measures associated with the transaction. Factless facts are a simple collection of dimensional keys which define…
We have all come across times when our customer wants to know how the organization is currently doing. They often want to know how they…
Often management looks for bottlenecks in corporate processes so that they can be streamlined or used as a measurement of success for the organization. In…
This blog post will focus on loading transaction fact tables, subsequent posts for peoiodioc and accumulating snapshots will follow in the coming weeks. Loading fact…
In this blog post I will provide an example of how I implement Type II dimensions in my data warehouses. The process I go through…
Joining fact tables can be done but there are some inherent risks so you need to be careful when joining fact tables is required. In…
A conceptual model is a representation of a system, made of the composition of concepts which are used to help people know, understand, or simulate…