DATE OR DATE KEYS IN FACT TABLES

arat at 06h26
13
Jul
2010
DATE OR DATE KEYS IN FACT TABLES

I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date dimension for the actual dates. I am told it doesn't cost much but at an enterprise level with hundreads of such queries.....is it worth.


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 : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Storing Date Keys in dimension tables versus fact tables
I have a question about the decision to store date keys in fact tables, and dimension tables. It seems to me that it is sometimes more effective to store date keys in the dimension table instead of the fact table, particularly if that date could be used
How to manage nulls in Fact talble
Hello, I am new with data warehousing. I need some help with following questions 1. should the nulls be left as nulls in fact table or should they be replaced with some number that might never be used like -7 or -1. If they should be replced with -1/-
Date Dimension with multiple keys at different levels, is that normal?
Hi, I have come accross a date dimension table design (in MS SQL which was made by somebody else) which not only has a key at it's most granular level (e.g. at the day level like the Microsoft adventure works example '20070101') but also has keys for
Eliminate Date Dimension Surrogate Key
We have always been using a sequential surrogate key for all our Dimension tables, including the Calendar Dimension. There is also a different school of thought (only for Calendar Dimension) where instead of using sequential keys, replace it with a
How to Model Fact table having 1:1 relationship with key Dimension attributes
hi all, Here is the scenario: Dimension attributes and Fact table for that Dimension attributes has one-to-one relationship. These dimension attributes are the key attributes for the purpose of fact table. The fact will be a factless fact. Other
Forums from same category
See also
more_less
Informations

13 Replies For the topic :
"DATE OR DATE KEYS IN FACT TABLES"

This topic has been viewed 2233 times.

Last message :
13/07/2010 at 06h26 by "arat"