title: How to populate my fact table with Pentaho Kettle
body: <p>I want to load data from a csv file containing many columns using PDI to the data mart that I designed and implemented on SQL Server, and I don't know how can I load the foreign keys of the dimensions into my fact table, can you give me an idea about how to acheive my goal?</p>
  
  <p>Here is the star schema of my data mart :</p>
  
  <p><img src="https://i.stack.imgur.com/UYXyQ.jpg" alt="enter image description here"></p>
  
  <p>and the csv file containing the raw data is composed by all the columns of the dimensions together except the primary keys, and the column contained in the fact : handling_time is also present in the csv file.</p>