More FactlessFacts

View previous topic View next topic Go down

More FactlessFacts

Post  dbadwh on 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

View user profile

Back to top Go down

Re: More FactlessFacts

Post  BoxesAndLines on 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.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: More FactlessFacts

Post  dbadwh on 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

View user profile

Back to top Go down

Re: More FactlessFacts

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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