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

star schema for process flow

2 posters

Go down

star schema for process flow Empty star schema for process flow

Post  azaman Fri Jul 11, 2014 4:43 pm

How do we model a star schema for a process flow ?
A process flow with several steps , creates a lot of attributes via a transaction.
If one is to store all the attributes in the fact table, the fact table might end up having
hundreds of attributes. Can I view each transaction as a separate fact and create star
schema for each transaction for each step in the process flow ? Would this be a workable
solution ?

Arif Zaman

azaman

Posts : 2
Join date : 2012-02-29

Back to top Go down

star schema for process flow Empty Re: star schema for process flow

Post  nick_white Sun Jul 13, 2014 7:55 am

azaman wrote:
If one is to store all the attributes  in the fact  table, the fact table might  end up having
hundreds of attributes.
I assume you meant Dimension and not Fact table as you don't store attributes in a fact table?
If your process has a relatively fixed sequence of steps then consider using an accumulating snapshot fact table.
It is common practice to have individual fact tables for each event in a process as well as an overall accumulating snapshot fact

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Back to top

- Similar topics

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