Course Dimension

I am trying to create a data mart around training completion/non-completion for our company's learning and development program. An obvious candidate dimension would be 'course', but there are two different types of courses - those that belong to a curriculum and certification (looks like a hierarchy), and those that are extra-curricular ad hoc courses. What is the a best way to model this, with one or two dimension tables?

Curriculum and course are two different things, so there are two dimensions but not two dimensions for course.

You would have a course dimension and a curriculum dimension. There would be a bridge table to record which courses belong to which curriculums. There would also be a fact table for enrollment. Curriculum may or may not be a dimension of the latter depending on wither or not you know the student enrolled in the course to satisfy a particular curriculum. If you don't, you can always analyze progress toward completion of a curriculum by combining data from the curriculum bridge and enrollment facts.

I think that's where I am doubting myself in how I need to structure the tables, or the bridge tables to be exact.

In the operational system (source) there are the following tables:

transaction

enrolments (PK enrolmentid, FK learningid)

master/attribute

curriculumcourses (PK id, FK learningid, FK parentid)
learningobject (PK learningid)
coursecompetency (PK id, FK learningid, FK competencyid)
competency (PK competencyid)