Beyond Facts and Dimensions Flashcards
1
Q
What is the difference between a Mapping Fact table and a Bridge table.
A
both used for Many to Many relationships
Bridge - ComboKey always link to one dimension
MappingFact - may link to one or more fact or dimension tables