-
Urgent! Advice needed on resolving Many-To-Many Relationships
I have a fact table where a single record may have multiple permutations of a single attribute so I need some advice as to how I may go about handling the relationships of these attributes to their appropriate dimension.
As an example, a person may have a single record in the fact table but may list up to 5 different States in that record which go back to a State Dimension.
What is the best approach to associate those 5 States for that 1 individual to the State dimension?
So this isn't a true many to many relationship in the sense that the same individual isn't listed 5 times in the fact table for each State. But rather that the 1 individual is listed in the fact table but may list many States in the single record.
If more clarification of the problem is required, please let me know but I believe the issue is pretty straight forward as I've explained.
Thanks much for any advice whatsoever!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|