Can a combination of a Fact and Dimensions constitute a inferred conformed dimension?

View previous topic View next topic Go down

Can a combination of a Fact and Dimensions constitute a inferred conformed dimension?

Post  B.O_GUY on Thu Apr 16, 2015 8:56 pm

We have one policy fact and 5 dimensions surrounding it, linking all these will always produce a query result where the granularity is one row per policy. Can we use this 'Inferred Policy dimension' as a conformed dimension to link other subject areas? lets say claim subject area which will have policy FK's in it?

B.O_GUY

Posts : 1
Join date : 2015-04-16

View user profile

Back to top Go down

Re: Can a combination of a Fact and Dimensions constitute a inferred conformed dimension?

Post  ngalemmo on Fri Apr 17, 2015 9:56 am

You could, but it is not a dimensional model. The table you describe is, in dimensional terms, a fact-less fact, not a dimension. Fact tables need to stand on their own. You would propagate the foreign keys in that fact to other facts during the load process.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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