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

One Fact Table or Two

2 posters

Go down

One Fact Table or Two Empty One Fact Table or Two

Post  KKumar Sun Apr 12, 2015 11:47 am

I am working on a star schema for a construction project model. We have 2 groups of users- one who wants to see only approved projects and the other group want to see project (approved and unapproved).

One option was to build 2 facts, one only with approved and other one with all the project. But this option will increase ETL Maintenance and increase db storage.

Second option was to create one fact table with all the projects and adding an indicator to the fact (Approved or Unapproved) and then creating a view that filters only approved projects for the first group of users. This option is less load on ETL but not sure if keeping indicators in fact is good idea.

Not sure if there is any other option.

Please advise.



Posts : 22
Join date : 2011-07-29

Back to top Go down

One Fact Table or Two Empty RE: One Fact Table or Two

Post  hkandpal Mon Apr 13, 2015 8:47 am

you should try the 2nd option, keeping the indicator in your fact. You can store the indicator in a junk dimension. If tomorrow you decide to have stage other than approved and unapproved for a project then this way you don't have to change the ETL code.



Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

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