A quick review about Dimension key.
Dimension keys uniquely identify each record in a dimension table. The purpose of dimension keys is to relate one dimension table record to a fact table record. Thus, the dimension key must be stored in both the dimension table and the fact table.
