Merge contact and account, or what?

View previous topic View next topic Go down

Merge contact and account, or what?

Post  AMB on Tue Dec 11, 2012 7:17 am

I have a fact table where each transaction is a donation. The donation can be made by a contact or an account.
My initial plan was to merge contact and account (becoming donor), but contacts can also have relationships with accounts (as a contact of some type). The account's contact can also make donations in their own right.

Current thought is to have 2 columns in the fact table - one for contact, the other for account. The non-relevant one being set to 0 to enforce correct granularity.

Downside of that is that it makes querying more complex as the user will have to check whether each donation is by a contact or an account.

My other thought is to use a view/other table as donor, but I'm concerned about performance.

Anyone have a better approach?
Thanks
Andrew

AMB

Posts : 1
Join date : 2012-12-11
Location : UK

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