title: How do I avoid complex joins in star schema?
body: <p>My fact table holds a user score in a course he took. Some of the details of the course, which I have to show on the report, comes from more then one table (in the actual OLTP db).<br>
  Do I create a none normalized version of that course entry in a dimension table?<br>
  Or do I just join the fact table directly to the course table join to the other tables that describe this course (course_type,faculty who created this course etc)</p>