star schema for process flow
2 posters
Page 1 of 1
star schema for process flow
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
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
Re: star schema for process flow
I assume you meant Dimension and not Fact table as you don't store attributes in a fact table?azaman wrote:
If one is to store all the attributes in the fact table, the fact table might end up having
hundreds of attributes.
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
Similar topics
» star schema designing
» Help designing star schema
» Star Schema put to test!
» Star Schema vs All in one table
» Star Schema for MPP databases
» Help designing star schema
» Star Schema put to test!
» Star Schema vs All in one table
» Star Schema for MPP databases
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum