Shoulddd i use multiple fact table in this case

View previous topic View next topic Go down

Shoulddd i use multiple fact table in this case

Post  sathwik.uc1@gmail.com on Fri Apr 10, 2015 6:57 pm

I have  dimensions namely  Patient,staff,plan of care,therapy,date dimensions, insurance  and fact table  revenue and morover  1  plan of care can lead to  many therapies and  patient can  admit as many times should i use multiple fact table??

Please let me know if my question is not proper??

sathwik.uc1@gmail.com

Posts : 2
Join date : 2015-04-10

View user profile

Back to top Go down

Re: Shoulddd i use multiple fact table in this case

Post  ngalemmo on Sat Apr 11, 2015 4:43 pm

Maybe, maybe not. What does the fact table represent?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

reply for question

Post  sathwik.uc1@gmail.com on Sun Apr 12, 2015 12:51 pm

Fact table represent diagnosis charge and therapy charge measures and the otherwarehouse keys...Please suggest me the appropriate model

sathwik.uc1@gmail.com

Posts : 2
Join date : 2015-04-10

View user profile

Back to top Go down

Re: Shoulddd i use multiple fact table in this case

Post  ngalemmo on Mon Apr 13, 2015 10:38 am

Grain, measures and timing usually determine what goes into a fact table. For example, you have charges related to procedures and facilities. It is common that these are represented by two different facts because they are at different levels of detail (grain). Diagnosis is usually a multi-valued dimension supported by a bridge.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Shoulddd i use multiple fact table in this case

Post  Sponsored content


Sponsored content


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