Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

PARTY dimension

2 posters

Go down

PARTY dimension Empty PARTY dimension

Post  Oleole 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

Back to top Go down

PARTY dimension Empty Re: PARTY dimension

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

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

Back to top Go down

Back to top

- Similar topics

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