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

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

2 posters

Go down

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

Post  B.O_GUY 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

Back to top Go down

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

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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