I am creating a data mart for a healthcare organization. Each patient is assigned a primary nurse. I need to be able to see total visits by primary nurse. So far I have patient and staff dimensions and a visit fact table. In a relational database I would have a patient-staff table that would show the relationship between the staff and the patient but I didn't think this was appropriate in a data warehouse. Any ideas on how to setup this up?
- Posts : 1
Join date : 2012-09-07
That would be your fact table. It holds all the keys and the event.
- Posts : 1212
Join date : 2009-02-03
Location : USA
Permissions in this forum:You cannot reply to topics in this forum