Dimension value or Fact table
2 posters
Page 1 of 1
Dimension value or Fact table
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
Re: Dimension value or Fact table
That would be your fact table. It holds all the keys and the event.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» joining dimension table to dimension and again fact table
» attribute on fact table or dimension table?
» Large Dimension table compared to fact table?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» attribute on fact table or dimension table?
» Large Dimension table compared to fact table?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum