12 ms·
I'd second this for dates. Every data warehouse I've been involved in building has always had a date table for ~100 years depending on the industry use case.
by shrikant 8y ago
I'd second this for dates. Every data warehouse I've been involved in building has always had a date table for ~100 years depending on the industry use case.
- gmfawcett 8y agoThis is especially common in data warehouses, as the dimension tables need to be populated with all of the attributes that a user will be searching/drilling on (including dates). I don't think I've ever come across a transactional system with a dedicated date table -- you usually have access to a good suite of date-manipulation operations in SQL -- but maybe there's a case for it.