SELECT with two FKs into a single dimension table (2 replies)
(MySQL.com) I'm dipping my toe into the Dimensional Database world. The short question is: if a Fact table has two FKs into a single Dimension table, can you distinguish the two fields without constructing multiple views of the Dimension table?
A concrete