title: Datawarehouse - How to Link dimensions
body: <p>Just got into datawarehousing and need your help to clarify a confusion. Lets say I have Employee dimension and Department Dimension. If I have a report that requires me to list fields from dimEmployee (Name, Salary, Position) and fields from department (DeptNo, Desc, Manager), how do I do that. Do I create a fact table(factless) that will be a joining table between these two dimensions ? Or do I need to design these two tables differently. Everyone talks about facts and dimension, but do we even considering linking dimension tables at all ? </p>
  
  <p>Thanks for your insights.</p>
  
  <p>RK</p>