Degenerate Dimension Question

View previous topic View next topic Go down

Degenerate Dimension Question

Post  scabral on Tue Mar 05, 2013 4:25 pm

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

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Degenerate Dimension Question

Post  BoxesAndLines on Tue Mar 05, 2013 11:11 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Degenerate Dimension Question

Post  scabral on Wed Mar 06, 2013 7:49 am

so would it be part of the policy dimension as an attribute?

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Degenerate Dimension Question

Post  BoxesAndLines on Wed Mar 06, 2013 10:08 am

Yes. It is an attribute of a policy.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Degenerate Dimension Question

Post  scabral on Wed Mar 06, 2013 10:10 am

thank you!

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Degenerate Dimension Question

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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