I assume address is important from the perspective of which location the doctors are delivering treatments/appointments/services. I would recommend setting up the address (or location) as one of your dimensions and associate each "treatment" fact to the appropriate address where the treatment was delivered.
Dig Deeper on Oracle data warehousing
Related Q&A from Mike Lampa
When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to ... Continue Reading