Type 1 data is something you’ll hear frequently when talking about OLTP (OnLine Transactional Processing) systems, and it can be common within a data warehouse as well. What is it? Type 1 data is essentially a permanent “current record” within a dimension. When a change occurs to a dimensional record, the change overwrites the previous…
Featured
You Can’t Make Filet Mignon out of Filet-o-Fish
To be clear, this article won’t be an indictment on the popular McDonald’s sandwich. Indeed, that was in itself a brilliant idea to combat flagging Friday sales in the predominantly Catholic neighborhood of a franchise owner. Due to most of his customers choosing to abstain from meat on Fridays, franchise owner Lou Groen famously made…
Rock the Data! 