Recursive Relationships in Source System

[rf001]

Hello,

I need your help...
for example there is a table Courses. Each line in the table represents the details of a single course. There is a recursive relationship in the table i.e. A course has another course as a pre-requisite. How to model this situation in dimensional modeling?

[hkandpal]

Hi,

one approach is to flatten the data and store in one row. Do you know maximum how many levels you can go ? is it fixed like maximum 10 level or 15 level or you dont know it can grow to any numbers.



thanks

[rf001]

Do you mean levels in the dimensions..? if yes, then it can be any number of levels.. it does not matter..

[ngalemmo]

Prerequisites are not really recursive, right? If they had taken the necessary prerequisite, it doesn't matter if they met prerequisites of the prerequisite course.

Anyway, if you must deal with recursion, store the relationships in an exploded hierarchy bridge table.

[Sponsored content]