Merge contact and account, or what?
Page 1 of 1
Merge contact and account, or what?
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
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
Similar topics
» How to deal with non-durable NK with split/merge records
» SCD using MERGE statement
» Need to merge fact tables
» SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete
» Task Factory Dimension Merge SCD Transform (v2.0)
» SCD using MERGE statement
» Need to merge fact tables
» SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete
» Task Factory Dimension Merge SCD Transform (v2.0)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum