title: Cross-reference table...dimension or fact?
body: <p>Beginner Dimensional-Modeling question:</p>
  
  <p>How do you model relationships between dimensions outside of a formal 'business process'? For example, say you were modeling a Fantasy Baseball league. Some obvious dimensions would be Team and Player, and an example fact would be the result of a player coming to bat. What I'm confused about is how to simply keep track of which players are on which team.</p>
  
  <p>In Third Normal Form I'd have a cross reference table with Team and Player FK's, and any additional fields which pertain specifically to the combination of the two (recruitment date, benched-player indicator, etc). Would this be any different with a star schema? If not, is this table considered a fact table then, with no numerical attributes?</p>
  
  <p>The part that confuses me is that this cross-reference table is never much use on its own. It would only make sense when joined to other fact tables, to get the list of players on a team associated with another fact/process. This makes it feel more like a dimension than a fact.</p>