Dimension without a link to fact

View previous topic View next topic Go down

Dimension without a link to fact

Post  SnowShine429 on Tue Apr 02, 2013 2:03 pm

Hi Everyone,

I am in the process of designing a Data Warehouse using star schema technique. I have two tables that am going to convert into Data Warehouse dimensions - Accounts and Contacts(one account can have multiple contacts). The measures in the fact table are at the account level and so there is no direct link between our fact tables and the Contacts table. Please note that there is no directly link between transactions and Contacts even in our OLTP/source system. I am sure this is a common scenario but I canít seem to figure to the best way to design this. Do you guys have any ideas?
Thanks in advance for all your help!!

SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: Dimension without a link to fact

Post  BoxesAndLines on Tue Apr 02, 2013 2:27 pm

If the source system does not track the relationship, then neither can you.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Dimension without a link to fact

Post  SnowShine429 on Tue Apr 02, 2013 5:11 pm

Thank you, do you suggest not pulling this table into the DW at all?

SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: Dimension without a link to fact

Post  BoxesAndLines on Tue Apr 02, 2013 7:19 pm

That would be a question for the users.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Dimension without a link to fact

Post  Mike Honey on Wed Apr 03, 2013 5:47 pm

I think this fits a known pattern in DW/BI. I would model your scenario using a Bridge / Factless Fact table to relate the Accounts to the Contacts. This table does not have any measures, just simply the Account and Contact Keys, with one row per relationship.
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Dimension without a link to fact

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