Rules for Dimension Design
Rules for Dimension Design[@more@]
- Do not include any characteristic into your cube if it is not used by any query. For possible future usage, it can be included into DSO.
- Between a navigational attribute VS. a characteristic, the first option is better for load performance and the second option is better for query performance
- Minimize the size of dimension table
- Minimize the number of dimensions, but it is more important to minimize the size of dimension tables
- For high cardinality characteristics, use Line Item Dimension
- For high cardinality dimensions, use B-Tree index
- If number of characteristics is less than or equal to 13, create one dimension for each of them and mark all dimensions Line Item Dimension.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/119153/viewspace-1029466/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
