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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create a fact table or use surrogate keys in dimensions?
What if the "main" facts occur at a much lower frequency than changes to user-company relationship? For example, user changes from Company1 to Company2 to Company3, but there are only facts happening when user is at Company1 and Company3. You would never know that user ever was at Company2...- Cridal
- Post #3
- Forum: Data Warehousing/Big Data
-
Create a fact table or use surrogate keys in dimensions?
Hi, I have a general dimension modeling question. Let's say I have dimensions called CompanyDim and UserDim. Each user belongs to a company (so Company can be considered an attribute of a User). Both dimensions contain other attributes that are of type 2. What is the best way of keeping track...- Cridal
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
