Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimension without a link to fact

3 posters

Go down

Dimension without a link to fact Empty Dimension without a link to fact

Post  SnowShine429 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

Back to top Go down

Dimension without a link to fact Empty Re: Dimension without a link to fact

Post  BoxesAndLines Tue Apr 02, 2013 2:27 pm

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

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

Back to top Go down

Dimension without a link to fact Empty Re: Dimension without a link to fact

Post  SnowShine429 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

Back to top Go down

Dimension without a link to fact Empty Re: Dimension without a link to fact

Post  BoxesAndLines Tue Apr 02, 2013 7:19 pm

That would be a question for the users.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Dimension without a link to fact Empty Re: Dimension without a link to fact

Post  Mike Honey 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.
Mike Honey
Mike Honey

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

http://www.mangasolutions.com

Back to top Go down

Dimension without a link to fact Empty Re: Dimension without a link to fact

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum