title: How to import data into star schema data warehouse.
body: <p>I have searched everywhere on the web to find out how I can import data into a star schema data warehouse. A lot of the stuff online explain the design of the star schema and data warehouse but none explain how exactly data is loaded into the DW. Here is what i've done so far: </p>
  
  <p>I am trying to make an application of high school basketball statistics for each player.   </p>
  
  <p>I have: </p>
  
  <ol>
  <li>A list of all of the players name, height, position and number</li>
  <li>A list of all of the high schools </li>
  <li>list of all of the schedules </li>
  <li>list of conferences </li>
  <li>statistics(points, rebounds, steals, games played, etc)  for each player for the current year. </li>
  </ol>
  
  <p>I assume the the stats would be my fact table and the rest are my dim tables. </p>
  
  <p>Now the million dollar question --How in the world do get the data into that format appropriately?</p>
  
  <p>I tried simply importing them to their respective tables but dont know how they connect. </p>
  
  <p>Example: there are 800 players and 400 schools. each schools has a unique id (primary key). I upload the players into dim players and schools into dim schools. Now how do I connect them?</p>
  
  <p>Please help. Thanks in advance. Sorry for the rambling :) </p>