FACT or DIM or both?
2 posters
Page 1 of 1
FACT or DIM or both?
Hi
I am really struggling with the design of one of my Star Schemas. The granularity of the Star Schema is Individual Engagements. This is a transactional model that captures every engagement with an individual. Each engagement is captured in the FACT with the dimensions Engagement Type, Individual, and Location etc....
Engagements have Engagement Outputs not all Engagements have Outputs and there is even Engagements Outputs without an Engagement. I started to design a Star Schema around Engagement Outputs but most of the Dims are the same as Engagements apart from 'Enagement Output Type'. Also some of the questions the business wants to answer are around the types of outputs that came from an Engagement. But they still want to answer questions such as “Count of Unique individuals engaged in career planning” Career planning being an Engagement Type.
Should I try and have the one FACT containing Engagements and Engagement Outputs? If so would Engagements become a Dimension?
Thanks,
Gary
I am really struggling with the design of one of my Star Schemas. The granularity of the Star Schema is Individual Engagements. This is a transactional model that captures every engagement with an individual. Each engagement is captured in the FACT with the dimensions Engagement Type, Individual, and Location etc....
Engagements have Engagement Outputs not all Engagements have Outputs and there is even Engagements Outputs without an Engagement. I started to design a Star Schema around Engagement Outputs but most of the Dims are the same as Engagements apart from 'Enagement Output Type'. Also some of the questions the business wants to answer are around the types of outputs that came from an Engagement. But they still want to answer questions such as “Count of Unique individuals engaged in career planning” Career planning being an Engagement Type.
Should I try and have the one FACT containing Engagements and Engagement Outputs? If so would Engagements become a Dimension?
Thanks,
Gary
gary1975- Posts : 2
Join date : 2013-06-17
Re: FACT or DIM or both?
Hi Gary,
I would probably keep Engagements and Engagement Outputs as separate Facts, as they clearly have unique granularity. Mixing granularity in one Fact table is almost always not a good idea.
Good luck!
Mike
I would probably keep Engagements and Engagement Outputs as separate Facts, as they clearly have unique granularity. Mixing granularity in one Fact table is almost always not a good idea.
Good luck!
Mike
Similar topics
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Cost plans for projects - One fact table or several fact tables?
» Unknown number of relationships from dimension to fact until fact loaded
» Multiple Fact Tables vs. Consolidated Fact Table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Cost plans for projects - One fact table or several fact tables?
» Unknown number of relationships from dimension to fact until fact loaded
» Multiple Fact Tables vs. Consolidated Fact Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|