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

More FactlessFacts

2 posters

Go down

More FactlessFacts Empty More FactlessFacts

Post  dbadwh Mon Nov 14, 2011 3:53 am

Hi,
Currently we have a situation. We need to link lot of dimension tables. To link we have used factless fact tables. Now we have lot of factless fact tables. How to limit the same and any restriction or rule available for number of fact/factless fact tables in a data mart?

dbadwh

Posts : 31
Join date : 2011-09-30

Back to top Go down

More FactlessFacts Empty Re: More FactlessFacts

Post  BoxesAndLines Mon Nov 14, 2011 10:20 am

Call the Kimball Group to review you design or hire someone to do the same. It doesn't sound like you've grasped the concept of a factless fact table.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

More FactlessFacts Empty Re: More FactlessFacts

Post  dbadwh Mon Nov 14, 2011 11:27 am

hi,
There are three ways we can link the dimension to dimension:
1. Fact Tables
2. Bridge Tables
3. Factless Fact Table

When there is no measure or facts available, we can link it through bridge or factless fact tables. Else how we can link the bridge tables when there is a requirement to link the multiple dimension tables without facts?

dbadwh

Posts : 31
Join date : 2011-09-30

Back to top Go down

More FactlessFacts Empty Re: More FactlessFacts

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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