Party (Person/Organization) Dimension

View previous topic View next topic Go down

Party (Person/Organization) Dimension

Post  DWModeler on Thu Dec 15, 2011 6:40 pm

Hi,

I'm working on a model that needs party as a super type and person and organization as sub types. I read Kimball's Interesting Trio of Snowflakes and have a question about implementing that approach. Instead of referencing Person/Organization as a FK in Party dimension, I think reversing the relationship will work better i.e. Refer to Party as FK in Person and Organization.

Any comments are appreciated!

Thanks

DWModeler

Posts : 7
Join date : 2010-09-23

View user profile

Back to top Go down

Re: Party (Person/Organization) Dimension

Post  DWModeler on Wed Dec 21, 2011 2:27 pm

Please share your experience how you modeled this in dimensional model and why

Thanks in advance

DWModeler

Posts : 7
Join date : 2010-09-23

View user profile

Back to top Go down

Re: Party (Person/Organization) Dimension

Post  BoxesAndLines on Wed Dec 21, 2011 4:33 pm

I built a single dimension that sourced the data from the best available source. For each source for a party, I maintained a cross reference table to manage the keys. Informatica IDQ managed all of the rules around matching and consolidation.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Party (Person/Organization) 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