PARTY dimension

View previous topic View next topic Go down

PARTY dimension

Post  Oleole on Fri Apr 20, 2012 1:03 pm

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


Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Re: PARTY dimension

Post  BoxesAndLines on Fri Apr 20, 2012 1:10 pm

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

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

View user profile

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