Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

1 fact table vs 3 fact tables

2 posters

Go down

1 fact table vs 3 fact tables Empty 1 fact table vs 3 fact tables

Post  shinji23 Tue May 21, 2013 6:21 pm

Hi,

I have question about fact table. Currently, we have one fact table which contains data from Lab, Medicine and Surgery. Our fact table currently have about 30 measure attributes (we combined all required attributes and flatten the table). Since three source do not have any common attribute, in our fact table, we have lot of 'n/a' attribute values.

If sources do not have any common attributes, would it be better to create 3 fact table using conformed dimension?

I was trying to build cube with SSAS, and seems like I can build single cube with multiple fact table, and I am not sure what would be trade offs for breaking our fact table to three vs current design.

Thank you.

shinji23

Posts : 11
Join date : 2012-01-19

Back to top Go down

1 fact table vs 3 fact tables Empty Re: 1 fact table vs 3 fact tables

Post  ngalemmo Tue May 21, 2013 9:08 pm

It would be customary to use 3 fact tables.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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