Dimension value or Fact table

View previous topic View next topic Go down

Dimension value or Fact table

Post  rolson on Fri Sep 07, 2012 1:13 pm

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?

rolson

Posts : 1
Join date : 2012-09-07

View user profile

Back to top Go down

Re: Dimension value or Fact table

Post  BoxesAndLines on Fri Sep 07, 2012 2:16 pm

That would be your fact table. It holds all the keys and the event.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum