Question
Why is a bridge table used in dimensional modeling?
Select an option. Your answer will be checked instantly.
Correct Answer: A. To resolve a many-to-many relationship between facts and dimension members
Explanation:
A bridge stores associations and sometimes allocation weights for multivalued relationships.
Examples include customers belonging to multiple groups or patients having multiple diagnoses.
Leave a Reply