Recursive Relationships in Source System

View previous topic View next topic Go down

Recursive Relationships in Source System

Post  rf001 on Fri Apr 26, 2013 5:50 am

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?
avatar
rf001

Posts : 23
Join date : 2010-12-16

View user profile

Back to top Go down

RE: Recursive Relationships in Source System

Post  hkandpal on Fri Apr 26, 2013 8:24 am

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


Last edited by hkandpal on Fri Apr 26, 2013 3:17 pm; edited 1 time in total

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Recursive Relationships in Source System

Post  rf001 on Fri Apr 26, 2013 10:47 am

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

Posts : 23
Join date : 2010-12-16

View user profile

Back to top Go down

Re: Recursive Relationships in Source System

Post  ngalemmo on Fri Apr 26, 2013 8:58 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Recursive Relationships in Source System

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum