In dimension Project, there is business logic that Project Number and Project Name can change over time. Unfortunately, I cannot get any durable key directly from the source system. Is there a way how to deal with this situation? How to generate Project ID column - in this example is acting as Durable key?
See desired dimension structure.
Project ID - durable key not from source system, I need to generate it.