Degenerate Dimension Question
2 posters
Page 1 of 1
Degenerate Dimension Question
I'm designing a Daily Snapshot Fact table to store Premium information (Written Premium, Earned, Unearned, etc...) for homeowner's insurance policies. Each policy has a deductible amount of either $500, $1000, or $1500 that we would like to track and analyze. It seems like a dimension even though it's a numeric field, but i don't think it requires it's own dimension table. Would this be something that would be stored as a degenerate dimension in the fact table?
The deductible could also change at any time if the policyholder decided to take a higher/lower deductible.
thanks
The deductible could also change at any time if the policyholder decided to take a higher/lower deductible.
thanks
scabral- Posts : 58
Join date : 2012-05-02
Re: Degenerate Dimension Question
No. A degenerate dimension would be something akin to a Policy Identifier. It is an source system identifier used commonly to access the fact, e.g. Order Identifier, Loan Identifier, etc.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Degenerate Dimension Question
so would it be part of the policy dimension as an attribute?
scabral- Posts : 58
Join date : 2012-05-02
Re: Degenerate Dimension Question
Yes. It is an attribute of a policy.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Question on breaking out Degenerate Dimension to separate dimension
» Degenerate dimension question.
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» To Degenerate or not to degenerate... that is the question.
» Should I use a degenerate dimension or create a junk dimension?
» Degenerate dimension question.
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» To Degenerate or not to degenerate... that is the question.
» Should I use a degenerate dimension or create a junk dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum