• Joining the 2 tables into 1, you lose the data normalization that was done.

    Do as you wish, it's your choice.

    At some point, depending on what is done, you may lose keys to the castle.

    A key is a KEY, where Names (even a Department), can change and overlap.

    Keys in the fact tables, and then pick up the descriptions as needed.

    It may not happen with this example, but if you start out on this path, it will eventually happen.