A table with a multipart key whose purpose is to capture a many-to-many relationship that can’t be accompanied by the natural grain of a single fact table or a single dimension table.
A table with a multipart key whose purpose is to capture a many-to-many relationship that can’t be accompanied by the natural grain of a single fact table or a single dimension table.