Browsing All posts tagged under »Fact Table«

Tracking History with Slowly Changing Dimensions

September 24, 2011

0

In this post I’d like to show a few of the different ways to maintain history. As anyone who has been in data-warehousing for a while can attest to, the two most common scenarios that business users want to see are the data as it was (Kimball Slowly Changing Dimension Type 2) , or as-is […]

Dimensional Modeling Worst Practices

May 16, 2011

2

As a consultant I see a lot of BI/DW solutions with various clients, and am often called in to fix performance issues. Often times developers/architects will ignore the Ralph Kimball methodology, or try to “improve it” by breaking a few rules. So I thought it might be worthwhile for me to post some of the […]

Data Modeling Conundrum Follow up

March 17, 2011

9

As a follow up to my previous post on a Data Modeling Conundrum in January (see https://jsimonbi.wordpress.com/2011/01/16/data-modeling-conundrum/) I left it open as to what the appropriate dimensional model should be. To recap from my first post, let’s say that I’m trying to track Marine Incidents. Zero or many vessels may be involved in an incident, […]

Data Modeling Conundrum

January 16, 2011

4

A post on the Kimball forum found at www.rkimball.com has raised a question very similar to one I worked on five years ago when I implemented an Oracle OLTP system capturing Marine Incidents, and the associated data mart for reporting. The question was this: How to model an incident when an incident may involve zero or many […]