Joining Dimensions in a data warehouse - is it possible?
Posted: Tue Jan 02, 2007 3:06 pm
Hi All,
I have a situation wherein I need to look into probability of Joining 2 dimension in a data mart which we are designing.
I am exploring the possibility of joining two dimension using joiner table (this I am doing coz I need to show many- to- many relationship between these dimensions). i.e. this joiner table becomes a kind of fact table but not exactly one.
This joiner table can then be linked to the fact table as well.
Any one out here has tried doing it? What are challenges? Can it be done? What are limitations?
Suggestions if any would be highly appreciated.
Regards,
Santosh.
I have a situation wherein I need to look into probability of Joining 2 dimension in a data mart which we are designing.
I am exploring the possibility of joining two dimension using joiner table (this I am doing coz I need to show many- to- many relationship between these dimensions). i.e. this joiner table becomes a kind of fact table but not exactly one.
This joiner table can then be linked to the fact table as well.
Any one out here has tried doing it? What are challenges? Can it be done? What are limitations?
Suggestions if any would be highly appreciated.
Regards,
Santosh.