Recursive Relationships in Source System
3 posters
Page 1 of 1
Recursive Relationships in Source System
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?
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?
rf001- Posts : 23
Join date : 2010-12-16
RE: Recursive Relationships in Source System
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
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
Re: Recursive Relationships in Source System
Do you mean levels in the dimensions..? if yes, then it can be any number of levels.. it does not matter..
rf001- Posts : 23
Join date : 2010-12-16
Re: Recursive Relationships in Source System
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.
Anyway, if you must deal with recursion, store the relationships in an exploded hierarchy bridge table.
Similar topics
» Source System Analysis
» Business Logic: DWH vs. Source system
» Deletes in the source system for Type-2...
» Bus Matrix - Business Process -to- Source System not 1:1?
» multi ERP source system, single DW load strategy
» Business Logic: DWH vs. Source system
» Deletes in the source system for Type-2...
» Bus Matrix - Business Process -to- Source System not 1:1?
» multi ERP source system, single DW load strategy
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum