PARTY dimension
2 posters
Page 1 of 1
PARTY dimension
Beeing Friday today, is it time for party dimension ?
For an insurance company Is it ok to have a party dimension including:
- all kinds of customers - Private and organisation customers
- employees
and including as attributes:
- dwelling
- contact person (employee)
- customer score
this will be a type 2 SCD, or is this really a fact table ?
Any con's against this solution ?
Comments will be appreciated.
Ole
For an insurance company Is it ok to have a party dimension including:
- all kinds of customers - Private and organisation customers
- employees
and including as attributes:
- dwelling
- contact person (employee)
- customer score
this will be a type 2 SCD, or is this really a fact table ?
Any con's against this solution ?
Comments will be appreciated.
Ole
Oleole- Posts : 12
Join date : 2012-02-15
Re: PARTY dimension
I'll bring the chips and beer.
It is always ok to have a party dimension.
The party dimension is a dimension not a fact.
I like to keep addresses separate from the party dimension. I can leverage it other places independent of the party living/working there. I've been known to even snowflake the party dimension to the address dimension. It essentially becomes my household identifier.
It is always ok to have a party dimension.
The party dimension is a dimension not a fact.
I like to keep addresses separate from the party dimension. I can leverage it other places independent of the party living/working there. I've been known to even snowflake the party dimension to the address dimension. It essentially becomes my household identifier.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Party (Person/Organization) Dimension
» 3rd Party Review
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» bridge table and junk dimension on customer dimension (bank/credit union)
» Loading and cleaning "randomly" updated, timestamped data from a 3rd party
» 3rd Party Review
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» bridge table and junk dimension on customer dimension (bank/credit union)
» Loading and cleaning "randomly" updated, timestamped data from a 3rd party
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum