How to build dimensions from SCD tables Having the foresight to begin collecting data from our production environment several years ago, I have a table with a following structure-

Part
Status
Startdate
Enddate

I can write a relational join, but how do I then go about including this in my project? What should I do in the DSV and in the Dimension relationships?
in the BIDS, open your project and double click on your DSV file, you can right click any where and add a table and then do the rest of steps like adding a relation

look at images

Step 1 
Step 2 

Is that what you meant