title: Look up surrogate keys and Populate fact table
body: <p>I have 8 <strong>surrogate keys</strong> that I need to <strong>lookup</strong> on the dimension tables and populate a fact table. I created <strong>8 lookups</strong> to the dimension tables, and then use the <strong>merge join</strong> and <strong>sort</strong> components to merge the data into one result set for insertion into <strong>dimension</strong> table. My worry is that there's a lot of merging and sorting that takes place before I do an insert, and the performance is not good. What is the best way for achieving what I explained above?</p>