Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Time/Date Dimension, Surrogate Key or not
Well that is interesting! I don't usually work with facts tables that need a date field where the date is either an unknown or a 'not applicable'. The facts I work with are transactional - financial transactions for banking, wholesale/retail sales, delivery shipments, inventories, etc. and...- cray101
- Post #13
- Forum: Data Warehousing/Big Data
-
Time/Date Dimension, Surrogate Key or not
Kimball does not actually say you have to use a surrogate key for the time dimension. In fact he implies that a date object probably would be used for the time key. Check out his first book Data Warehouse Toolkit where he talks about time dimension. Here's a direct quote in case you don't...- cray101
- Post #11
- Forum: Data Warehousing/Big Data
