I'm building a dimensional model, and it will have several dates. Since they're all really just FKs from the Date table, I need to be able to name them different things in the fact table so people will know which date is which and to avoid duplicates. I just can't figure out how to do it yet.
thee is no restriction on changing the name of FK column in relational model. For logical model and FK attributes - you need to clear the check box in "Tools>Preferences>Data Modeler>Model>Logical>FK Attribute name synchronization" and then you can change the name of FK attribute.