Trivial ques-Resolving a Many-to-Many (m:n) Relationship..why reqd
kapoor_dh at 06h38
30
Dec
2009
Trivial ques-Resolving a Many-to-Many (m:n) Relationship..why reqd
Hi,
This is a very basic cinfusion which I am having.
I have a scenario where the 2 entities are having many to many relationship,I see that it is must to resolve these relationships.
Example : A Fax number directory Entity 1: Person details,Entity 2: Fax numbers,now here a person can be associated with more than one fax numeber and a fax number can be associated with more t
Hi,
This is a very basic cinfusion which I am having.
I have a scenario where the 2 entities are having many to many relationship,I see that it is must to resolve these relationships.
Example : A Fax number directory Entity 1: Person details,Entity 2: Fax numbers,now here a person can be associated with more than one fax numeber and a fax number can be associated with more t
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
I've read quite a bit on dimensional modeling but this would be my first go in reality. Any help would be greatly appreicated. Here's what I've got...
An existing subset of our DW would be:
Fact_tx
Dim_Customer
Dim_Product
One of our source
I have been fortunate (or unfortunate?) to only have encountered one to one dimension/fact relationships in my previous DW experience. However I am now looking at medical claim payments, and have a service line fact. It relates to several dimensions
I have a student quarterly registration fact table. Every student has academic programs (majors) associated with him/her and each student can have up to 5 of them. And each major can start and end at different times and has multiple parameters including
I need help to design dimension model. Detail of Dimension are as following:
Dimension : Student, School
Fact : Grade
1. Class_Year
2. School
3. Area
4. City
Analysis Requirement are to drill up /down by above given hierarchy
there is :
M:1
Hi all. I know the common standard practice for many to many relationships is to use a bridge table, and I've done that already in my model. But I've come across a situation where I'm thinking of using a group table related directly with the fact. Let'
Forums from same category
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Search
See also
Informations
1 Replies For the topic :
"Trivial ques-Resolving a Many-to-Many (m:n) Relationship..why reqd"
This topic has been viewed 1790 times.
Last message :
30/12/2009 at 06h38 by "kapoor_dh"
