Q
Problem solve Get help with specific problems with your technologies, process and projects.

Star schema advice for healthcare data warehouse

We are in the process of designing a star schema for the data warehouse in the healthcare industry. How would we handle doctors that have one of more address? We need to show all the places where the doctors practice.
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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close