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