1.

What do you mean by factless table?

Answer»

Factless tables do not contain any facts or MEASURES. It CONTAINS only dimensional keys and DEALS with EVENT occurrences at the informational level but not at the calculational level. As the name implies, factless fact tables capture relationships between dimensions but lack any numerical or textual data. Factual fact tables can be categorized into two categories: one that describes events, and the other one that describes conditions. Both may have a significant impact on your dimensional modeling.



Discussion

No Comment Found