Question on Dimenstion refernece to another dimension.

View previous topic View next topic Go down

Question on Dimenstion refernece to another dimension.

Post  mru22 on Wed Jun 29, 2011 12:23 pm

I am trying to Add a PersonIncdient Dimension And Claims fact table as shown below:


Dimension
PersonIncident
PersonIncidentKey
AffectedPersonId
IncidentId
[CostCenterKey] <== Not Yet Added


Fact
Claims
PersonincidentKey
DateKey
[CostCenterKey] <== Not Yet Added


I have an existing Dimension CostCenter which in the operational table has a foreign key to the PersonIncident Table.

I was wondering if I should make the Foreign key directly to the fact table from cost center or should I keep the Cost Center Dimension foreign key reference in the PersonIncident Dimension ? A person Record can only be associated to one cost center so I think I could answer the same questions either way. I was trying to avoid snowflaked dimensions if possible.

So I wasn't sure what the tradeoffs are of going one route vs another, especially performance wise ?


Thank you.

mru22

Posts : 34
Join date : 2011-06-14

View user profile

Back to top Go down

Re: Question on Dimenstion refernece to another dimension.

Post  ngalemmo on Wed Jun 29, 2011 4:48 pm

I would make person and incident independent dimensions off the fact. The fact table would naturally infer the person and incident relationship.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Question on Dimenstion refernece to another dimension.

Post  mru22 on Wed Jun 29, 2011 4:51 pm

How about the Cost Center ? Since it was originally a foreign key in the Person, Should I key it into the fact directly as well ?


mru22

Posts : 34
Join date : 2011-06-14

View user profile

Back to top Go down

Re: Question on Dimenstion refernece to another dimension.

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