title: FactCurrentWorkItem and DimWorkItem tables in Team Foundation Server
body: <p>I'm trying to understand the relationship of the FactCurrentWorkItem and DimWorkItem tables in the Tfs_Warehouse database.</p>
  
  <p>About mid page at the link below it states:</p>
  
  <p><em>You can query for information about tasks, bugs, and other types of work items by using the work item tables in the following illustration. Each work item fact table uses the work item dimension table to store many details about the work items.</em></p>
  
  <p>I am surprised that there are many FactCurrentWorkItem to one DimWorkItem.  I would have expected the reverse so I have a misunderstanding of what is actually in the tables.  Can someone explain to me what is in them and their relationship?</p>
  
  <p><a href="https://docs.microsoft.com/en-us/vsts/report/sql-reports/table-reference-relational-warehouse-database" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/vsts/report/sql-reports/table-reference-relational-warehouse-database</a></p>