Sometimes we need to analyze our data based on the some specific value which are available only at fact table. In this case, the particular data will act as a dimension. This dimension is called as Fact Dimension.
Fact Dimension also known as Degenerated Dimension
Fact Dimension will be more helpful, when we need to categorize the data based on similar kinds of data.
Example: Invoice Number, Purchase Order No, Etc.,
Of course, we can maintain separate dimension table instead of using Fact Dimensions, but no benefit, because the dimension table grow in the same ratio of fact table growth. So by creating Fact dimension, we can avoid duplicate data and reducing memory consumption. Also it helps to improve the performance during data retrieval time.
No comments:
Post a Comment