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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly