In a previous article, I listed the benefits of using a dedicated date table and included a customizable script which enables you to quickly create your own version. One of my readers pointed out that he uses the date datatype, rather than using the smart integer key method, when working with SQL 2008+ databases. The [...]
|
||||||
|
|
Every Kimball Group book I’ve read, as well as every Data Warehouse class I’ve attended, has indicated that a Date Dimension Primary Key should be a smart integer key in the format YYYYMMDD (20110518) so I’ve always built my Date tables that way. However, Barnaby (Blog/Twitter) pointed out that I should be using a Date [...] This Wednesday I’ll be presenting at the Fort Worth SQL Server User Group. Come see me present: Data Warehousing – How to Convince “The Bobs” I got a meeting with the Bobs in a couple of minutes… Building your first Data Warehouse is a long, and often difficult process. How can you get your boss to [...] Calendar Tables are only useful if they reflect how your company evaluates its data. Therefore, any company using non-standard financial fiscal years and periods will require customization with their Calendar or Date Table. In this post, I’ll provide an example of how to do so using the M2M ERP System Database. For those who don’t [...] What is a Date (Calendar) Table? For the purposes of this article a Date Table is a dedicated table containing a single record for each day in a defined range. They include fields with descriptive attributes for each day such as Year, Month, Week, and whether a particular day is a work day or not. Date [...] It’s been a crazy few weeks. As I mentioned previously, I presented at two SQL Saturday Events in back to back weeks. I’m on the core committee for the North Texas SQL Server User Group SQL Saturday, so I was overwhelmed with things to do and couldn’t stop to blog. So, now that I’ve taken [...] I’ll be presenting at two SQL Saturdays back to back. You are taking advantage of SQL Saturday events, right? SQL Saturday Chicago is this weekend (3/26), and I’ll be presenting: Data Warehousing – How to Convince “The Bobs”
I got a meeting with the Bobs in a couple of minutes… Building your first Data Warehouse is [...] Anyone who reads this blog should know that I’m a fan of Todd McDermid and his free Kimball Slowly Changing Dimension Transform. For those of you who’ve not been following his blog, he was contacted by the Kimball Group and informed that he needed to stop using Kimball’s name for his free transform, the Kimball [...] I’m sorry that my posts haven’t been as regular as I’d like, but the good news is that we’re making great progress with the M-Data Analytics open source project. In order to provide the best benefit to my fellow Made2Manage users, please answer the following questions. What Version(s) of [...] Note: This is the last in a series of five “lessons” which I created for SQL University on the topics of Dimensional Modeling and Data Warehousing. Click here to read the rest of the series. I can haz assimilation? We are Borg – Bringing it all together. Now that we understand the basics of Dimension and [...] |
|||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles