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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Connection to time dimension with different grains
Tanks for tue answer. What i do not understand is how i should generate the foreign key in a fact table with quarterly grain. Could u help me there? Thanks! Olekova- Olekova
- Post #3
- Forum: Data Warehousing/Big Data
-
Connection to time dimension with different grains
Hello, I have two fact tables with a different time granularity. First fact table has the grain month, second has the grain quarterly. Should they use the same time dimension, or should I have a time dimension for each granularity? If I have a time dimension like this key year quarter month...- Olekova
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
