SQL Server 2008 Date data type as dimension key

VHF at 20h42
12
Feb
2010
SQL Server 2008 Date data type as dimension key

We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date with no time information) as the SK for the date dimension.

Anyone have first-hand experience with the new SQL 2008 Date data type? Have you bumped into any tools that don'

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Kimball or not Kimball type 2 dimension (sk as primary key)
We're using Oracle and I received the following (see below) from our architect about why we shouldn't create a new SK for every type 2 change. i.e. use a combination of date and sk as the primary key. Is this correct. Will it affect the creation of
Data Warehouse spread across 4 separate databases
Hello, I started with a new BI team. Our data warehouse was developed by consultants. I find the design very strange, but they insist that it uses BI best practices. I can't find any best practices supporting this set-up. Can anyone help me
ETL from Oracle to SQL Server 2008 Data Warehouse
Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a
Loading Fact Table with Type 2 Slowly Changing Dimension
I'm new to data warehousing .. sorry if this is a basic question. I have a type 2 slowly changing dimension already loaded and now I want to load a fact table. At least, I think it should be a fact table. A lot of the entities in the dimension table
Date Dimension refresh for all data marts nightly ??
We are working at client site where we recommended using the BUS architecture and we are using PPS Monitoring for dashboards. Our client has been re-building each data mart nightly for now and they are re-building each data mart dimdate dimension with row
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"SQL Server 2008 Date data type as dimension key"

This topic has been viewed 7637 times.

Last message :
12/02/2010 at 20h42 by "VHF"