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!
-
Dimensional Relationships
Thanks but I don't think that quite addresses the question and am also not really in agreement about the assertion that SKs are there to support SCD - I would say they are more there to reinforce best practice of not embedding contextual info in the lowest grain logic of the model - ie customer...- jed1971
- Post #3
- Forum: Data Warehousing/Big Data
-
Dimensional Relationships
WHat do people recommend as best practise for modelling relationships between dimensions (independent of facts) - thinking of things like customer and geography eg customer x is in Austin TX and that is recorded in the customer dimension but Austin also exists in the geography dimension with...- jed1971
- Thread
- Replies: 5
- Forum: Data Warehousing/Big Data
