- The Implicit fact column is added to a query when it contains columns from two or more dimension tables and no measures. The column is not visible in the results. It is used to specify a default join path between dimension tables when there are several possible alternatives or contexts.
- The implicit fact column must be based on the same fact around which the presentation catalog has been built. For example, if the presentation catalog contains information from the Order star, the implicit fact column must be based on the Order/Order-Item fact.
Implicit Fact Column
Subscribe to:
Post Comments (Atom)
ReplyDeleteGreat Article. As I read the blog I felt a tug on the heartstrings. it exhibits how much effort has been put into this.
IEEE Projects for CSE in Big Data
Spring Framework Corporate TRaining
Final Year Project Centers in Chennai
JavaScript Training in Chennai