Friday, September 24, 2010

Why don’t we have a time dimension instead of a date dimension?

Well, it is not practical.
A date dimension with 10 years of data has 3,650 rows. If it were a time dimension with precision to the second, it would have 315 million rows and would impact the data warehouse performance because it’s used everywhere

No comments:

Post a Comment